File name

[Pilar]

Hi,
Is it possible to show the Excel file name in a cell?

Thanks
Pilar

 

[Nick Hodge]

Pilar

=CELL("Filename")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0002.html

 

[Pilar]

Pilar

=CELL("Filename")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Pilar]

Thank you Nick. That work.

Pilar

Pilar

=CELL("Filename")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Pilar]

Thank you Frank. It is an interesting url.

I have used the formula to show File name only and that works.

Pilar