Comments:
I assume that you had used the Event Scheduler in Reuters Tools to run Excel macros and you have lost the schedule of events.
Every time you create a new event in the Event Scheduler a record of that event is entered into the events.dat file which is stored in the same directory as the Reuters Tools which by default is C:\Reuters\Rtools. If you changed workstations you can copy the old events.dat file to the new workstation. If you can find the original events.dat file you should be able to recover your lost events.
If you cannot find the events.dat file you will need to use the Event Scheduler wizard to create new events to run your macros at specific times.
You indicate that you are getting the Cannot Run Macro error. This problem is usually caused because the Event Scheduler cannot find the macro you are trying to run.
You can solve this problem in Step 2 of the event wizard. In the Macro Name text box you must enter the proper syntax. You can use the browse button to locate the full path and name of the workbook containing the macro. You may also need to add the module name containing the macro as well as the macro name. The syntax used depends on the version of Excel you are using. The types of syntax to be entered are displayed in Step 2 of the Event Scheduler wizard. You can use the Event Scheduler to modify each event and in Step 2 make sure the syntax is entered correctly.
|
