Log in

View Full Version : Excel macro


excelmacro0123
Dec 23, 2008, 07:42 AM
I need to run a macro that opens excel so I can kick off "application.ontime" basically my macro should run without me having to start excel, just have the computer and outlook running.

Is that possible?

StaticFX
Dec 23, 2008, 07:57 AM
Need more info:

When should this run? On boot, at a certain time?
How often? Every boot etc...

What do you mean kick off "application.ontime" is that a macro in excel?

More details please :)

excelmacro0123
Dec 23, 2008, 08:00 AM
It should run once a day, but it should run regardless if I have Excel open or not.

Application.ontime is what I was planning to use to run the macro at a certain time.
Please let me know if you need more info.

Thank you,

StaticFX
Dec 23, 2008, 08:24 AM
OnTime: Automatically Run Macros at a Set Time or Date. Application.OnTime (http://www.ozgrid.com/Excel/run-macro-on-time.htm)

excelmacro0123
Dec 29, 2008, 09:13 AM
Thank you,