how can I display the file location (ie:C/mydocuments..) and have it print on
my worksheet for future reference?
how can I display the file location (ie:C/mydocuments..) and have it print on
my worksheet for future reference?
File...page setup...customer footer (or header) ...then click the file path
icon. It will print the file name and path for you.
"medrvgc" wrote:
> how can I display the file location (ie:C/mydocuments..) and have it print on
> my worksheet for future reference?
Sometimes I want to see the filename in a cell - not only in header or footer on print.
I use this function
=CELL("filnamn";$A$1)
Sorry my version of Excel is in Swedish - please check help for exact way of writing in your language.
This function give me this info in the cell
L:\Lissu 2006\[Prislista.xls]Blad3
Path - filename - sheet name
Hope this helps!
Lissu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks