Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the true path to server (not mapped drive letter)?
I am attempting to include a footer on excel printouts that includes the path
name so I can later locate the file. Many users. Many with dissimilar drive mappings. The current path name is coming up as j:/john/worksheets. Whereas that works for me, that will not work for someone using a dissimilar mapped machine. Would like the path name to be \\FileServer17\FinanceGroup\John\Worksheets. Any suggestions? Is this a networking issue or excel issue? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the true path to server (not mapped drive letter)?
John wrote...
I am attempting to include a footer on excel printouts that includes the path name so I can later locate the file. Many users. Many with dissimilar drive mappings. The current path name is coming up as j:/john/worksheets. Whereas that works for me, that will not work for someone using a dissimilar mapped machine. Would like the path name to be \\FileServer17\FinanceGroup\John\Worksheets. Any suggestions? Is this a networking issue or excel issue? It's a networking issue, not an Excel issue. If you and your many users all access this particular directory from the same server (FileServer17), then open files in this directory using the UNC pathname \\FileServer17\FinanceGroup\John\Worksheets rather than J:\John\Worksheets. That is, avoid using mapped drives. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the true path to server (not mapped drive letter)?
In Windows explorer move the file to a networked drive so that it is
stored on the server and not on your local drive. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked Check Boxes | Excel Discussion (Misc queries) | |||
Disable CUT via toolbars or shortcut keys | Excel Discussion (Misc queries) | |||
Disable "Cut" only | Excel Discussion (Misc queries) | |||
Material Condition formula | Excel Discussion (Misc queries) | |||
Macros and Toolbars | Excel Discussion (Misc queries) |