Excel 2007 - File Path location

[Kevin]

Hi

In old excel the web toolbar used tell me the file location including the
details of the server. Now however for both the location tab and formula
=cell("filename") return the file path without the server detail ie it shows
the drive I have mapped it to on my computer. I prefer the server details as
I can send this link to other people who can find the file regardless what
drive they have mapped the server to.

Any quick fix to display the server details instead of directory detail

thanks

 

[Dave Peterson]

First, it's always a good idea to include a reference to the worksheet/workbook
in that formula:

=cell("filename",a1)
(I use the cell that contains the formula)

If you don't use it, then the formula will return the name of the
workbook/worksheet that was active when excel recalculated.

Second, (and I don't have access to a network share to test), but I thought that
you'd see whatever you used to open the file.

If you opened it from the mapped drive, then you'll see the mapped drive letter.

But if you opened it from the shared drive, you'll see the \\server\path stuff.

====
But there are ways of translating between mapped drives and UNC paths.

I searched google for:
vba mapped drive unc path

And found a hit from Rob Bovey:
http://groups.google.co.uk/group/mi...oup:microsoft.public.excel*+#c3cd25028147e026

or

http://snipurl.com/3v5dx