I have set up an Office Macro task to call a macro inside an Access database which successfully executes.
To test the process, I modified the input file to cause the macro itself to fail. When I run the macro directly from inside Access, the dialog box for a run-time error appears allowing me to choose to End or Debug the process. However, if I run the Office Macro task from VisualCron, the job continues to run indefinitely until the timeout has been reached or I manually stop the job.
Is there a way to build in error handling into the VisualCron task so that the job would fail when the macro the task is running has a run-time error?
Thanks in advance for offering your ideas.