How can run an Excel macro program using DOS command?

  • Thread starter Thread starter Queenie
  • Start date Start date
Q

Queenie

I want to run an Excel macro program using batch job but
I don't know what the DOS command is?
 
Put the code in the Workbook_Open procedure of some workbook and use
the DOS command to open the workbook. However, do be aware that
depending on your security settings, XL may not enable the code at all
or it might display a "this file contains macros" warning dialog box
that will require human intervention.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top