Is there an Excel/VBA Timer for running a macro ~once an hour? 1

[jnameika]

Is there a way to have MS EXCEL kick off a macro once an hour? (working on the Access version, but in the meantime...) I have a report that is run ~ once an hour using imported data. I can't find anything that describes a timer or event that can do such a thing. Is this something I have to code or does someone have some code I can "borrow?"

MS system tools "Scheduled Tasks" is not an option due to policy restrictions.

 

[white605]

This link might get you started

http://www.ozgrid.com/Excel/run-macro-on-time.htm

This old world keeps spinning round - It's a wonder tall trees ain't layin' down

 

[NashProjects]

If you use application.ontime this will suit you perfectly.


for example

sub TestOntime

'put your code her

application.ontime now()+timevalue("00:01:00"), "Procedure_Name", now()+timevalue("00:00:30")

End sub


Run the sub once initally and then the sub will run every hour form then on untill you shut it down.

Hope that helps!!

Kind regards

Lee Nash

http://www.Nashprojects.com