Run an excel macro using a .bat file

[haywaro]

I can use a .bat file to run a word macro. I simply have the following line of code
"c:\programfiles\microsoftoffice\office\winword.exe"/m(macro name)

Note I do not include the brackets around the name.

I have tried everything and cannot get the same to work in excel.

In need the code to

1. Open excel
2. Open a spreadsheet
3. Run a macro which is saved in personal workbooks on the open spreadsheet.
4. Close excel.

Anyones help would be greatly appreciated!!!!!! I am stumped.

 

[Joe Was]

If Excel is regesterd on the PC then just run the file name from the bat file, it is the same as clicking on the file name in Windows Explorer. In the file you open us an Open Event from ThisWorkbook to run what you need when the Workbook is opened.


c:\temp\blabla.xls