http://support.microsoft.com/default...b;en-us;192689
HOWTO: Get UNC Path From a Mapped Network Share's Drive Letter


http://support.microsoft.com/default...b;en-us;160529
VBA: Sample Code to Return the UNC Path of a Network Drive

--
Regards,
Tom Ogilvy

"John Mansfield" wrote in message
...
Is it possible to get the full server name in the file path as opposed to
just the drive letter that it refers to?

For example, if I use

ActiveWorkbook.FullName

I get something like this:

L:\test.xls

The full server name for the drive letter L is:

mcssrv02\finserv

I would like the file path to read:

mcssrv02\finserv\test.xls

Thanks for your help.

Kim Mansfield