View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mahendhra Mahendhra is offline
external usenet poster
 
Posts: 6
Default Batch

Thanks!! It is working for me now.

"Norman Jones" wrote:

Hi Mahendra,

Try:

Application.Run ("File2.xls!YourMacroName")


---
Regards,
Norman



"Mahendhra" wrote in message
...
I have two files file1.xls & file2.xls. I first open file1.xls,
subsequently
through VBA code in file1.xls, I need to open file2.xls and execute an
macro
in file2.xls. Do anybody have suggestions?

I am able to open file2.xls through this command, but unable to execute
any
macro in that.
Workbooks.Open Filename:=

Thanks
Mahendhra