G
Guest
This is a re-post and hopefully with one of the replies I got the last time I can say this a little clearer and hopefully someone may know a solution to my problem
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 have the problem of the screen saver kicking on part way through and it creates a problem for some of my code. Harold Staff explained it best in his reply "Some network policies re-enables the screensaver automatically at certain intervals to ensure that all workstations are password protected after some time of "inactivity" -unfortunately defined only as mouse/keyboard activity." This is the exact situation I am in. Is there any way to disable this from VBA, I have tried several codes for disabling the screensaver but non of them seem to work. My other thought is to do something to make the computer stay active, and insert it into the code I have (22 modules and over 300 pages). I could really use some help and guidance on this. Is this even possible to do, prevent the "inactivity lock-out"
Running Windows XP and Excel 200
What can I do ??
Thanks for you time with this issu
Ti
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 have the problem of the screen saver kicking on part way through and it creates a problem for some of my code. Harold Staff explained it best in his reply "Some network policies re-enables the screensaver automatically at certain intervals to ensure that all workstations are password protected after some time of "inactivity" -unfortunately defined only as mouse/keyboard activity." This is the exact situation I am in. Is there any way to disable this from VBA, I have tried several codes for disabling the screensaver but non of them seem to work. My other thought is to do something to make the computer stay active, and insert it into the code I have (22 modules and over 300 pages). I could really use some help and guidance on this. Is this even possible to do, prevent the "inactivity lock-out"
Running Windows XP and Excel 200
What can I do ??
Thanks for you time with this issu
Ti