Excel VBA get Network path from local path

Hello,
In excel VBA, I need to get the ‘network path’ from the ‘local path’.
For example:
Local path=”n:\tmp”
Where n:\ is a network shared directory. Say the network host is "alfa" and the drive share name is "george"
The routine output should give "\\alfa\george\tmp"
Any ideas?

Thanks

Please Login or Register  to view this content.

great. thanks