Run a macro outside of Excel automatically
 

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

Run a macro outside of Excel automatically
 

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
wrote in message ...

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