Comments:
The most likely reason why your macro does not run is because Scheduler cannot find it. You need to provide the Scheduler Tool with the exact location of the workbook and the macro for it to work properly.
In Step 2 of 5 of the Scheduler wizard, you need to enter:
1. The full path to the location of the Excel workbook which contains the macro.
2. The name of the workbook followed by an (!) exclamation point.
3. The name of the macro.
For example, I set up a macro to run at a specific time during the night which was in the Temp directory on my local drive in a workbook called TESTSCHEDULE.XLS. The name of the sub routine was called Test. The entry in the Macro Name text box in Step 2 was:
C:\TEMP\TESTSCHEDULE.XLS!Test
The macro ran as scheduled.
You need to use this entry format in Excel 97, Excel 2000 and Excel XP.
|
