View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
neeraja neeraja is offline
external usenet poster
 
Posts: 2
Default 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.