Macro to disable screen saver

[snax500]

In Excel2000, I would like to have a macro that will do something every
14 minutes in order to stop the screen saver and logout from popping
up. It is a work PC and the screen saver and logout are defaulted by
the netork to go on every 15 minutes. I was thinking of something like:

SendKeys ENTER

but I don't want to use ENTER because I want the macro to run another
macro that runs my reports and using the ENTER may make my other macro
not run correctly if every 14 minutes Excel is hitting enter. Is there
a way to sendkeys without sending anything just so that it interupts
the screen saver and logout procedure?

THanks

 

[Bernie Deitrick]

snax,

Talk to your system admin about getting an exception to the policy, so that you can turn off your
screensaver.

HTH,
Bernie
MS Excel MVP

 

[snax500]

They said no.

 

[Jef Gorbach]

In Excel2000, I would like to have a macro that will do something every
14 minutes in order to stop the screen saver and logout from popping
up. It is a work PC and the screen saver and logout are defaulted by
the netork to go on every 15 minutes. I was thinking of something like:

SendKeys ENTER

but I don't want to use ENTER because I want the macro to run another
macro that runs my reports and using the ENTER may make my other macro
not run correctly if every 14 minutes Excel is hitting enter. Is there
a way to sendkeys without sending anything just so that it interupts
the screen saver and logout procedure?

THanks

Havent played with SENDKEYS within Excel nor real-time countdowns within,
but presume you specify which window/application to SENDKEYS to as per
vbscript...so point the "cursor" somewhere safe (say Notepad) before sending
the keystroke every 13-minutes then returning to Excel should proceed
without disrupting the report??

Alternately, search your local driver for either/both wscript.exe or
cscript.exe to see if Windows Scripting is avaiable, and if so, entertain
the Screensaver there so Excel can process the report without distraction.