DOS BATCH file to open excel and run macros

**dwr0211** · 08-08-2011, 12:13 PM

I need to open an excel workbook and run two separate macros from a dos .bat file.

Is this possible?

**dwr0211** · 08-08-2011, 12:14 PM

I am running Excel version 12.

**Chippy** · 08-08-2011, 01:20 PM

I don't think a .bat file can do this. Have a look at VBScript (.vbs file) instead.

**DonkeyOte** · 08-08-2011, 02:13 PM

You can use the .bat to open the file, however, you might want to use Workbook_Open of the file to trigger the routines...

Note you would need to account for Macro Security settings.... and you might also consider using a Scheduler of some sort.

DOS BATCH file to open excel and run macros

LinkBack

Thread Tools

Rate This Thread

Display

DOS BATCH file to open excel and run macros

Re: DOS BATCH file to open excel and run macros

Re: DOS BATCH file to open excel and run macros

Re: DOS BATCH file to open excel and run macros

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions