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
 
You must log in or register to reply here.

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

Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Run Access from Command Prompt 7
FreeDOS turns 25 years old: An origin story 2
Command Prompt v. Run Box? 2
Run Macro If Cell have "x" value 0
32 programs 9
How to create a bubble chart with more than 2 variables 0
Closing another cmd.exe window from batch script? Opposite of START cmd.exe /k "...." ? 4

Back
Top