Mapped vs Network drives

[Greg]

hi,

is there a way to show a network drive via formula when a drive is being
mapped?
Different users mapping of the same drive to a various letters is causing
issues.

I thought of writing an UDF combining a string with a network drive name
with a combination of cell("filename") & hyperlink function, but there has to
be an easier way.

Thank you,

 

[Bob Phillips]

Take a look at
http://vbnet.mvps.org/index.html?code/network/uncfrommappeddrive.htm

HTH

Bob

 

[Greg]

thanks, Bob. I'm on Vista though and it's not listed there