Run a macro automatically every 24 hours

[nenadmail]

How do I run a macro automatically every 24 hours? What's the code? And where do I put it in the code, at the end of the macro, right? (and I wanna be able to change it to whatever interval I like, 12 hours, hourly, etc)

Thanks!

[Kyle123]

You'd put it in the workbook open sub and set a scheduled task from within windows.

[nenadmail]

Can you guide me... I don't know how to schedule a task within windows...????

---------- Post added at 06:37 AM ---------- Previous post was at 06:24 AM ----------

So, there's no micro code that can do it? The only way is to "schedule a task"???

[Kyle123]

Well it depends if you have to have your workbook open 24/7. If you do then yes, but if you don't how will your workbook execute the code if it isn't open?

[nenadmail]

Right... yes.. that's the case, it's open 24/7.

[Kyle123]

Have a look at Application.Ontime

[nenadmail]

where do I look? What is that? Please understand I'm not a programmer... I just know how to copy paste code. If you can please provide a code for me, that would be the best... Thanks!

[Kyle123]

How can I provide some code when you haven't provided any?

Google it or open up the help feature, it's extremely straight forward, but this should get you going:
http://www.ozgrid.com/Excel/run-macro-on-time.htm

[nenadmail]

Thanks... but that's like a foreign language to me... here's the code I want to have repeated:

Please Login or Register  to view this content.

P.S. Initially, I thought it's just one or two lines of code I can just paste in here... that's why I didn't provide the code originally.

[Kyle123]

I think you want:

Please Login or Register  to view this content.

[nenadmail]

Thanks for your help!!!