View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Standen[_2_] Jeff Standen[_2_] is offline
external usenet poster
 
Posts: 56
Default 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