PC Review


Reply
Thread Tools Rate Thread

How can run an Excel macro program using DOS command?

 
 
Queenie
Guest
Posts: n/a
 
      5th Apr 2004
I want to run an Excel macro program using batch job but
I don't know what the DOS command is?
 
Reply With Quote
 
 
 
 
Tushar Mehta
Guest
Posts: n/a
 
      10th Apr 2004
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

In article <155ca01c41ae9$b4b37b20$(E-Mail Removed)>,
(E-Mail Removed) says...
> I want to run an Excel macro program using batch job but
> I don't know what the DOS command is?
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
There was a problem sending the command to the program. [Excel] serhat Microsoft Excel Crashes 8 4 Weeks Ago 01:58 AM
Run Excel Macro from Command Line Al Franz Microsoft Excel Programming 3 13th Jun 2005 08:18 AM
Can I run a macro from a command button in Excel? =?Utf-8?B?amFjY2hvcHM=?= Microsoft Excel Programming 3 16th Feb 2005 06:18 PM
Why won't Excel allow me to assign a macro to run from a command . =?Utf-8?B?bHRpbmRhMDE=?= Microsoft Excel Misc 3 21st Oct 2004 05:47 PM
Excel Macro: use of 'if' command Greg Microsoft Excel Misc 2 10th Mar 2004 10:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:01 AM.