PDA

View Full Version : [SOLVED] Application.ontime



philfer
02-20-2008, 12:36 PM
Hello,

Is there a way to get around using Application.Ontime with a workbook that isnt open?

Thanks

Bob Phillips
02-20-2008, 12:40 PM
What are you trying to do?

philfer
02-20-2008, 12:58 PM
I'm trying to run a macro at a certain time during the night/day but without it needing to be open i.e. it will work behind the scenes

Bob Phillips
02-20-2008, 03:12 PM
If you fire off an Ontime and then close the workbook, as long as Excel is still running, it will automatically open it.