File ID name in Excel

[Rene''48]

Hello Tech Support,

I am writing a macro in excel 2003:

I want to be able to use a macro command that will identify the file name I
am currently working in a given cell. Is there a macro code I can use that
will identify the name of the file I am currently working in?

Thank you for your help.

Rene'

 

[Per Jessen]

Hi

Try this:

Range("A1") = ActiveWorkbook.Name

Regards,
Per

 

[Howard31]

Hi Rene

Try using ActiveCell.Parent.Parent.Name

Hope this helps,