View Full Version : Solved: Auto Close WorkBook when Idle

12-17-2008, 06:33 AM
Hi all,

I?m trying to get XLD's macro to work from http://vbaexpress.com/forum/showthread.php?t=13017&highlight=TIMER (http://vbaexpress.com/forum/showthread.php?t=13017&highlight=TIMER) but have failed. It keeps coming up with an error with the below:

Application.OnTime Now + nElapsed, "Closedown", , False

also tried, with no luck:

Application.OnTime Now + nElapsed, "Closedown", schedule:=False

I come across this before and can?t figure out what I did to correct this and turn the timer off. Using Excel 2002

Could anyone please help !!


12-17-2008, 06:41 AM
sorry guys, it working now. came back from lunch and hey presto !

not sure what went on but....

Application.OnTime Now + nElapsed, "Closedown", schedule:=False

seems to be ok