Dynamically displaying share name

Joined
Apr 28, 2002
Messages
4
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
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
This does not work?

=SUBSTITUTE(SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",
CELL("filename",A1))),"[",""),"]","")
 
Upvote 0
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!.....
 
Upvote 0
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.
 
Upvote 0
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)
 
Upvote 0
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.....
 
Upvote 0
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!
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top