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
Bookmarks