Automatically Run Macros Using Task Scheduler

[mlarson]

This is probably simple but I just don't know how to do it. What I do know is how to set up a task in Task Scheduler and I have it set to open my Excel file: Workbook1.xlsm. This task is set to run at 7am each morning. Workbook1.xlsm has a bunch of different macros in it.

What I'd like to do is to have each of those macros to run automatically when the file is automatically opened by Task Scheduler. How would I go about doing this?

Thanks for your help.

 

[John_w]

You could call the macros from the Workbook_Open event handler in the ThisWorkbook module in Workbook1.xlsm.

 

[mlarson]

John, apologies for my ignorance on this topic. Would these steps be correct?
1. Open Workbook1.xlsm
2. Go to Developer, then Visual Basic, then CTRL+R to bring up the project library
3. Under Workbook1.xlsm I see "Microsoft Excel Objects" and I should double-click on "ThisWorkBook"

What do I do after this step? I'm not sure what to include in the macro. Would it look something like the following?

Sub RunAllMacros()

Run Macro1
Run Macro2
Run Macro3

End Sub

 

[abi_learn_vba]

mlarson,

Double click on Thisworkbook. On the code window you have two dropdowns. On the left(it would be "General" by default) select Workbook. On the Right (it would be "Declarations" by default) select Open. When you select those tow you will get the code as shown below:

Private Sub Workbook_Open()

End Sub

Make sure you Call the Macros that you wanted to run in an sequential order as per your requirement.

Private Sub Workbook_Open()
Call Macro1
Call Macro2
Call Macro3
End Sub

-Abi

 

[mlarson]

Thanks, Abi! Appreciate the help.