Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 / XP - Running .XLS with Macros via Task Scheduler
We've just moved to Excel 2002 and XP and are having some problems with
running scheduled spreadsheets via the Task Scheduler. We have an account that has Administrator privileges and have done the self-certification thing so that when we manually run the spreadsheet, there are no prompts requiring user interaction. However, when we run it under the Task Scheduler (with the account still logged in) the spreadsheet hangs at a sub that prints a named range. We're seeing the same behavior on a second PC and a different spreadsheet that hangs when it tries to send an Outlook note. Again, the spreadsheet runs fine and with no user interaction if manually kicked off. Anyone bumped into this and solved it - or have any suggestions of what to try? Thanks in advance for any help you can offer! James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running excel macro by scheduler | Excel Discussion (Misc queries) | |||
Excel still running in task manager after closing the application | Excel Discussion (Misc queries) | |||
task scheduler | New Users to Excel | |||
Lost items in task scheduler | New Users to Excel | |||
Getting Task Scheduler To Use Current Excel Session When Opening F | Excel Discussion (Misc queries) |