excel macro on startup from DOS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After I start excel from a DOS .BAT script I want a macro to then be automatically executed. (To do this with MS Word you just put /Mmacroname after the path name of the executable, but this does not seem to work)
 
Excel doesn't support macro execution from the command line. As
an alternative, you can name the macro Auto_Open and this will
execute when the workbook is opened.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

roblit said:
After I start excel from a DOS .BAT script I want a macro to
Click to expand...
then be automatically executed. (To do this with MS Word you just
put /Mmacroname after the path name of the executable, but this
does not seem to work) .
 
Hi roblit
AFAIK there is no similar functionality in Excel. Though you can create
a macro in Excel and name it Auto_Open (). This will automatically
executed on startup
Or you can paste your code in the workboot_open event procedure of the
workbook module

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DOS..BAT file problem from VB 1
Batch file initiation from Excel macro? 1
Run a macro from another workbook in the QAT 1
Running a macro from the command line 1
Excell 2000 macro will not open file! 1
Automatically run an Excel macro 3
No Workbook at Startup 4
Keep macros from being ran under the tools option in the menu bar 3

Back
Top