Is there a formula to display the File Name in a cell (Say O49) ?

--
Corey ....
The Silliest Question is generally
the one i forgot to ask.

=CELL("filename")

Go to http://office.microsoft.com/en-us/ex...346271033.aspx

"Corey" wrote:

Is there a formula to display the File Name in a cell (Say O49) ?

--
Corey ....
The Silliest Question is generally
the one i forgot to ask.

Thanks

Tried that origianlly but only displayed the 'CELL("filename")' as text.,
Is Ok now

Thank You


Corey....


"Sheeloo" wrote in message
...
=CELL("filename")

Go to http://office.microsoft.com/en-us/ex...346271033.aspx

"Corey" wrote:

Is there a formula to display the File Name in a cell (Say O49) ?

--
Corey ....
The Silliest Question is generally
the one i forgot to ask.

=cell("filename")
will evaluate to the workbook name that was active when excel recalculated.

=cell("filename",a1) will return that workbook/worksheet for the cell with the
formula.

You can visit Chip Pearson's site for a bunch of formulas:
http://www.cpearson.com/excel/excelF.htm#FileName

ps. The workbook has to be saved at least once.


Corey wrote:

Is there a formula to display the File Name in a cell (Say O49) ?

--
Corey ....
The Silliest Question is generally
the one i forgot to ask.

--

Dave Peterson