LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 158
Default Automated Excel Workbooks and Task Scheduler

Hello all,

I have several automated Excel workbooks running in task scheduler (they
kick off every 5 minutes). Everything was working just fine until 4/23/2008
between 12:00am & 1:00am. After that, my Excel workbooks become hung in Task
Manager (i.e. after the macro runs and the Excel workbook appears to be
closed, the Excel process shows as still running in Task Mgr). Additionally,
these hung Excel processes eat up alot of memory & cpu (it pegs the cpu usage
at 100%) and drags the entire speed of my computer down to nothing.

I have been running these programs for about 2 years. I think there must
have been a windows update or a norton virus scan update that effected task
scheduler. I don't have any issues if I open the Excel workbook by hand
(program runs and once the workbook closes, the Excel process disappears from
Task Mgr).

Does anyone have any suggestions on how to go about figuring out what to do?

Thank you for your help.

MSweetG222
 
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
task scheduler does not reconize excel NickHK Excel Programming 0 December 8th 06 02:31 AM
Use Task Scheduler to automatically run Excel workbook John Hazel Excel Programming 0 May 22nd 06 02:06 PM
Detect Excel was started with Windows Task Scheduler RB Smissaert Excel Programming 1 January 1st 05 11:40 AM
Excute a Excel worksheet with Task Scheduler Randy[_15_] Excel Programming 0 September 8th 04 01:53 PM
Excel 2002 / XP - Running .XLS with Macros via Task Scheduler James Cox Excel Programming 0 August 19th 03 03:50 AM


All times are GMT +1. The time now is 10:51 PM.

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

About Us

"It's about Microsoft Excel"