kenwagner@netzero.net
New Member
- 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
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