Addressing the Excel file in which the macro is present.
 

Hi,

I have an Excel file in which i have a Macro which uses
many different Excel files. How do I address the file in
which the Macro is present in my Macro. I am not
capturing the name of the file in which this macro is
present. So how can i address this file from my Macro??
Is there any command called This.excelfile or something??
pls let me know.

I would appreciate any help
Thanks,
Neeraja.

Addressing the Excel file in which the macro is present.
 

Hi Neeraja,

You were very close: try

Thisworkbook.name

Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com

"neeraja" wrote in message
...
Hi,

I have an Excel file in which i have a Macro which uses
many different Excel files. How do I address the file in
which the Macro is present in my Macro. I am not
capturing the name of the file in which this macro is
present. So how can i address this file from my Macro??
Is there any command called This.excelfile or something??
pls let me know.

I would appreciate any help
Thanks,
Neeraja.