| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
| batch file to open multiple worksheets | Excel Discussion (Misc queries) | |||
| How can I batch open a txt file in excel 2003 and save back as a . | Excel Discussion (Misc queries) | |||
| Create a batch file from a number of Excel File | Excel Programming | |||
| Batch Open and Save | Excel Programming | |||
Threaded Mode
