How can run an Excel macro program using DOS command?

Q

Queenie

I want to run an Excel macro program using batch job but
I don't know what the DOS command is?
 
T

Tushar Mehta

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
 

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

Need Help with Macro Security 1
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
Macro warning in word 1
Passing parameters from DOS shell to a word macro 1
Converting .xls to .xlsx via DOS command 1
DOS batch files 7
Access denied when running Excel from DOS prompt with runas comman 5
Running macro when communicator message is received 0

Top