Re: get network path name of active workbook
Quote from xmarkusx;181941I am searching desperately for a solution how to get the network path of an open file. I know how the get it including a mapped letter (like C:\data\...), but I don't know yet how to get it with the network path (like \\srv1\data\..).
I realize this thread is old, however, I had a similar question and was able to find an answer. Thought I'd share it for others. The Below will return the UNC path of the open workbook. Useful if the Workbook resides on a Network Share.