Batch file to open and run two macros in excel

[ctbanker]

Hi All,

I want to create a batch file to open and run two different macros in excel. The reason I need a batch file is to do this automatically for me without me having to manually open the excel file. For some reason, when I use Task Scheduler to open my excel file (with macros), it simply opens the file but doesn't run the macro. Help would be greatly appreciated!!

 

[mjbeam]

Not a batch file, but a script. Save the file with the extension ".vbs".

Option Explicit

Dim xlApp, xlBook

Set xlApp = CreateObject("Excel.Application")
xlApp.visible=true
Set xlBook = xlApp.Workbooks.Open("~your_path_here\~your_workbook_here.xlsm", 0, True)
xlApp.Run "~your_macro_here"
xlBook.Close
xlApp.Quit

Set xlBook = Nothing
Set xlApp = Nothing

 

[ctbanker]

And if you want to run two macros, simply add the following (under "xlApp.Run "~your_macro_here"):

xlApp.Run "~second macro name here~"

Sorry, I'm very new to vba, vbs, etc. Thanks for your help!

 

[ctbanker]

Nvm, I think I figured it out. Thanks for your help!!!