Schedule a macro to run

Hello,

I want to scedule a macro to run in a workbook but that workbook does not contain the macro. So,

I have a macro in outllook that saves a new workbook to a drive folder each morning.

It is on that workbook that I want to deploy the macro on. So i want to open the workbook and run the macro but there is no macro in the workbook. Is this possible?

If it also helps I have the macro(.bas) saved in the same folder.

Hope that makes sense.

P.S I have found video on youtube on how to schedule a macro but that is when the workbook contains the macro.

Ross

.
Not certain I completely understand what you are wanting to do except .... run a macro at a specific time that affects a different workbook
other than the workbook where the macro resides ???

Anyway ... in short ... have you considered using the built-in feature of the Windows Scheduler ?

Hi rosscortb,

The following attached two files probably demonstrate what you want:
a. ExcelForumProcessDataInAnotherWorkbookPerSchedule.xlsm - Excel file that controls scheduling and runs your macro
b. ExcelForumProcessDataInAnotherWorkbookPerScheduleData.xlsx - Dummy Data File

Instructions for use (Basic Mode):
a. Put both files in the same folder
b. Open the .xlsm file and 'Left Click' the 'Stop ...' Yellow Shape'
c. Add your Macro to the file in an Ordinary Code Module.
d. Select the day or days of the week you want your Macro to run
e. Select Yes or No if you want your macro to run on Holidays that fall on an allowed day of the week
f. Add holidays to the holiday list if you want your macro to run on Holidays
g. Put the Time of Day you want your Macro to run and the Macro Name in the List
h. Save the file
i. Test to make sure everything works
j. Select (Stop then) Reschedule All Macros
NOTE: The Excel File MUST be open 24/7 and the computer can not be sleeping at the time the Macro is to run.

Instructions for use (Advanced Mode):
a. Perform all the 'Basic Mode' steps.
b. Add the call to your Macro inside a Wrapper Function (see below).
The Wrapper function will display when your Macro ran when you 'Left Click' the 'List ...' Yellow Shape.

Typical code in Ordinary Code Module ModUserMacros (feel free to Modify):

Please Login or Register  to view this content.

Lewis