Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running excel macro by scheduler Dan Excel Discussion (Misc queries) 1 August 19th 07 11:48 PM
Excel still running in task manager after closing the application Willem Excel Discussion (Misc queries) 0 December 5th 06 01:56 PM
task scheduler Big Jim New Users to Excel 0 June 1st 06 07:00 PM
Lost items in task scheduler Big Jim New Users to Excel 0 June 1st 06 06:59 PM
Getting Task Scheduler To Use Current Excel Session When Opening F Carl Excel Discussion (Misc queries) 2 March 18th 06 02:46 PM


All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"