Run a macro outside of Excel automatically

  • Thread starter Thread starter hans.domian
  • Start date Start date
H

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
 
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
 
Back
Top