Dynamically displaying share name

[kenwagner@netzero.net]

Hello,

I was trying to find a way to dynamically display the complete network share name address of where my spreadsheet is storeed (i.e. \myservermysharemylibmyfile.xls).

I've used =CELL("filename",C2) to dynamically display the address of a file BUT!!... if the location is a Network location only the drive I've mapped is displayed in the cell.

HOW CAN I GET THE ENTIRE NETWORK PATH NAME TO DISPLAY?

Thanks!
Ken

[Anne Troy]

This does not work?

=SUBSTITUTE(SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",
CELL("filename",A1))),"[",""),"]","")

[kenwagner@netzero.net]

No... that displays the same info. It will display the drive i've mapped to (ex: F:SharedFilesmyfile.xls

I want it to display:
\myservermyshareSharedFilesmyfile.xls

"F:" is mapped to \myservermyshare

Thanks!.....

[EdE]

If you access the file via the server route and not the mapped route, it will show the full path. Setting the shortcut to the server route instead of the mapped route and it should solve your problem.

[Chris Davison]

see if this is returns anything different to =cell("filename",a1) :

=INFO("directory")

(I suspect it won't, but I'm at home, so can't test with different drive mappings etc)

[kenwagner@netzero.net]

Chris,
that did not work.

=INFO("directory") displayed my temporary directory Excel puts the file into while i open it.

thanks for the thought though.....

[kenwagner@netzero.net]

EdE,

you are correct..... but, it would be nice to display entire Network path name if someone has it mapped. This way if it is printed and distributed the complete path will be displayed on the printout.

Thx!