full UNC path in footer
 

How do I display the full UNC path (i.e. \\server\home\user\filename.xls)
instead of the mapped drive path (x:\filename.xls) in the footer of an excel
(or word) document?

All of our user's home folders are mapped to Drive X and when they put the
path on the footer of the document they are looking on, it shows
x:\filename.xls. It is not a problem if you know who printed the document,
but if you don't, then it is a pain to search for that particular document in
all the users' home folders

There is an article at MS to get a UNC Path

http://support.microsoft.com/kb/q151027/
ACC: How to Return an UNC Path from an Existing Drive Letter

--
HTH

Bob Phillips

"muttdaemon" wrote in message
...
How do I display the full UNC path (i.e. \\server\home\user\filename.xls)
instead of the mapped drive path (x:\filename.xls) in the footer of an
excel
(or word) document?

All of our user's home folders are mapped to Drive X and when they put the
path on the footer of the document they are looking on, it shows
x:\filename.xls. It is not a problem if you know who printed the
document,
but if you don't, then it is a pain to search for that particular document
in
all the users' home folders