ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Mapped vs Network drives (https://www.excelbanter.com/excel-worksheet-functions/253130-mapped-vs-network-drives.html)

Greg

Mapped vs Network drives
 
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

Bob Phillips[_4_]

Mapped vs Network drives
 
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




Greg

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

"Bob Phillips" wrote:

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



.



All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com