Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WNetGetUniversalName - how to implement in VBA?
I have a workbook on a network directory. I also happen to have the network
directory mapped on my machine, but various users may have it mapped differently, or not at all. I need to verify (on open) that the workbook is still located in the network directory, and that someone hasn't moved it or saved a copy elsewhere, because the data they enter needs to be available to all users. I tried activeworkbook.path, fullname, and curdir, but all of those just gave me my mapped drive letter (w:) I did a google search and it looks like WNetGetUniversalName translates the local path to the full network path, but for the life of me I can't get it to work in VBA. Does anyone have a code snippet that implements this that they would be willing to share? Thanks, Keith -- The enclosed questions or comments are entirely mine and don't represent the thoughts, views, or policy of my employer. Any errors or omissions are my own. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to implement xbrl | Excel Discussion (Misc queries) | |||
Do anyone know how to implement the function? | Excel Programming | |||
Is there a way to implement more than 3 conditional formats | Excel Worksheet Functions | |||
How to implement an iRtdServer? | Excel Programming | |||
Help WNetGetUniversalName ... in vba | Excel Programming |