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
|