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!
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!
Last edited by nenadmail; 08-01-2012 at 07:20 AM.
You'd put it in the workbook open sub and set a scheduled task from within windows.
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"???
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?
Right... yes.. that's the case, it's open 24/7.
Have a look at Application.Ontime
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!
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
Thanks... but that's like a foreign language to me... here's the code I want to have repeated:
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.Please Login or Register to view this content.
I think you want:
Please Login or Register to view this content.
Thanks for your help!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks