FullName vs FullNameURLEncoded
 

I am trying to return the URL address for the open workbook on my LAN system.

What I want returned is something like: \\pvfs-nucpro\pvnucpro\chem\test.xls

Instead I receive: W:\Excel\test.xls

Is there a way to retreive the URL for a file?

I've tried ThisWorkbook.FullName and ThisWorkbook.FullNameURLEncoded, which
gives the same result.

FullName vs FullNameURLEncoded
 

Maybe...
http://support.microsoft.com/default...;en-us;Q192689
How To: Get UNC Path From a Mapped Network Share's Drive Letter
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Posse John"
wrote in message
I am trying to return the URL address for the open workbook on my LAN system.
What I want returned is something like: \\pvfs-nucpro\pvnucpro\chem\test.xls

Instead I receive: W:\Excel\test.xls

Is there a way to retreive the URL for a file?
I've tried ThisWorkbook.FullName and ThisWorkbook.FullNameURLEncoded, which
gives the same result.