Application.OnTime question

[EXCELMACROS]

Hi all,

I'm trying to find a way to kick off an "application.ontTime" without having
to start Excel Manually, so the Macro needs to first start Excel and then run
my application. Is that possible? and how?

 

[JLGWhiz]

There is an obscure tool in Windows using the Start>All
Programs>Accessories>SystemTools>Scheduled Tasks. Open the scheduling wizard
and follow the prompts.

 

[EXCELMACROS]

Thank you so much... now do you know if this schedulling task will work even
if I'm not log into my computer (computer is on)

 

[JLGWhiz]

I have never tried it, so I cannot say for sure, but the information I read
indicates that it will. Try it and see.

 

[Chip Pearson]

Thank you so much... now do you know if this schedulling task will work even
if I'm not log into my computer (computer is on)

It is an option you can set when you create the task. You can specify
that you must be logged on or you can specify to run the task even if
you're not logged on.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)