Run a macro outside of Excel automatically

[hans.domian]

Hi all,

I have written a macro within of Excel.
How can I run this macro outside from Excel in background within a BAT-file like this:

@echo off
Title EXCEL-Macro Start Batch File
"C:\Program Files\Microsoft Office\Office10\EXCEL.EXE"  - <param> <name of macro>
exit

Which params I have to define after the term 'EXCEL.EXE'   ?

Thanks in advance

 

[Jeff Standen]

I'm not sure that you can. What you can do is create a book that calls your macro in the workbook.open event, and then run that file from your batch.

Jeff

Hi all,

I have written a macro within of Excel.
How can I run this macro outside from Excel in background within a BAT-file like this:

@echo off
Title EXCEL-Macro Start Batch File
"C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" - <param> <name of macro>
exit

Which params I have to define after the term 'EXCEL.EXE' ?

Thanks in advance