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'

Hi

Try this:

Range("A1") = ActiveWorkbook.Name

Regards,
Per

"Rene''48" skrev i meddelelsen
...
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'

Hi Rene

Try using ActiveCell.Parent.Parent.Name

Hope this helps,

--
A. Ch. Eirinberg


"Per Jessen" wrote:

Hi

Try this:

Range("A1") = ActiveWorkbook.Name

Regards,
Per

"Rene''48" skrev i meddelelsen
...
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'