hi
try this one!
in the cell you want to have the file name type
=cell("filename")
-via135
Will Wrote:
Is there a field or function in Excel that would insert a full path to
the
spreadsheet on the file system along with the name? For example:
\\ourserver\sharedfiles\some\directory\path\my-excel-spreadsheet.xls
You often get handed a printout of a spreadsheet, and it would really
be
nice if the printed version of the spreadsheet had a way to reference
its
own location so you could easily get back to it starting from the
printed
version.
In Page Setup I see a way in the header to insert &File to get the
filename
only, but that does not insert a full path.
--
Will
--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread:
http://www.excelforum.com/showthread...hreadid=511289