ExcelBanter - Automatic Macro in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Automatic Macro in Excel (https://www.excelbanter.com/excel-programming/290036-automatic-macro-excel.html)

MMM[_2_]

Automatic Macro in Excel

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.

BrianB

Automatic Macro in Excel

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.

---
Message posted from http://www.ExcelForum.com/

All times are GMT +1. The time now is 01:03 PM.