Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This question may seem a little strange, I have looked around but haven't found an answer that seems to work. I have a program in excel that I wrote that takes between 25 and 45 minutes to run (automates process and data collection and creating reports, hundreds of files). I use windows XP and at work, I ahve the problem of the screen saver kicking on part way through and it creates a problem for some of my code. It is a security issue for work, when the screensaver activates it locks the computer and you ahve to log back in to unlock it (and they won't change it). Is there a way to either disable this with VBA, or put something into my code (22 modules and over 300 pages) that will occasionally do something that will keep the computer active. I have screenupdating turned off for the whole process to help speed things along. Also if it matters I am running exccel 2002
What can I do ?? Thanks for your tim Timmoth Operations Assistant |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dual monitors / screen saver issue | Excel Discussion (Misc queries) | |||
Macro as Screen Saver | Excel Discussion (Misc queries) | |||
Restore the auto save function, it was a life saver. | Excel Discussion (Misc queries) | |||
VBA code slows to a snails crawl when screen saver activated | Excel Programming | |||
Turn off Screen Saver by Macro | Excel Programming |