filename in Cell
 

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

filename in Cell
 

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

"Leer587" wrote:

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

filename in Cell
 

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



"Leer587" wrote:

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

filename in Cell
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Leer587" wrote in message
...
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