Excel: Obtaining the filename

[mach27]

Hi experts

Please have a look at the scenario below in which I want to know the filename where the macro is activated.

Here's the scenario:
1. A macro is saved in Book1
2. The macro is activated in Book2

Result:
The macro should prompt the user that the filename is "Book2"


regards,
mach

 

[mach27]

never mind, I read from another forum that activeworkbook.name is what I needed.

 

[GlennUK]

You should post VBA questions in forum707 , but the quick answer is ActiveWorkbook.Name

Cheers, Glenn.

Beauty is in the eye of the beerholder.