network file location using a function

Posted by Ken on January 15, 2002 12:58 PM

Hi,

I want to be able to show the Network path location of my spreadsheet using a formula. This way if the location of the file changes the correct address will appear in the spreadsheet. Kind of like &[file] can show me the file name -- How or what can i use to show me "folder" address?

Thanks

Posted by Chris D on January 15, 2002 1:17 PM

=cell("filename",a1)

should do it

Posted by Ken on January 15, 2002 3:35 PM

Thanks!

Posted by Ken on January 16, 2002 6:05 AM

i tried this and it displays the "mapped drive" from my PC.

I want the actual Network address to be displayed. (i.e. \\myserver\myfolder1\myfolder2/myfile )

Thanks...Ken

Posted by Chris D on January 16, 2002 12:12 PM

Sorry Ken,

this is what I use at work, and my knowledge of mappings is about as welcomed as a White House pretzel....

Have you tried the help file ?

Click on your function button (Fx), select "all" and scroll down to "CELL" then click on your help icon... it should explain a few more options

Hopefully, it might give you what you need
Chris

Posted by KEN on January 16, 2002 12:45 PM

I'll check it out Chris... thanks !