filename in Cell

[Leer587]

I have created a huge excel spreadsheet and will print it out. But before
doing so, I would like to insert a filename in a cell on this spreadsheet to
make reference where the actual file is residing in the server. I could do
this manually, but I thought Excel can do it auto via "Filename".

Thanks.
Leer587

 

[dlw]

not sure about that, but you can put the filename in a custom header or
footer for printing

 

[CLR]

A new file must first be saved..........then,

=CELL("filename",A1)

or, if you don't want the SheetName included......

=MID(CELL("filename",A1),1,FIND("]",CELL("filename",A1)))


Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)