Automatic Macro in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I call Excel from a batch file:
"C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft\Microsoft Excel.lnk" "C:\Program Files\Corda50V2\chart_root\examples\data\homeTest_1_27_2004_run9.csv"
After it opens the file I want to designate a recorded macro to execute automatically (no clicking by me).
How do I do it?

Regards, MMM.
 
I suggest you point your batch file to open the workbook which contains
a macro in the On_Open event. Put the .csv open code into this macro
too.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Macro files will not open 1
Macro to import CSV file from fixed directory 1
Want Macro to save to .xlsx 2
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Run a macro outside of Excel automatically 1
XL 2003 / IE 6.00.2900 - Macro menu unavailable 3
Separate Macro from Workbook 9

Back
Top