Take a look at
http://vbnet.mvps.org/index.html?cod...appeddrive.htm

HTH

Bob

"Greg" wrote in message
...
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,

--
______
Regards,
Greg