Is it possible to have a code run automatically at 9am on weekdays?
Is it possible to have a code run automatically at 9am on weekdays?
Yes.
But for that you need to use either Task Scheduler or a third-party program.
You would set running times in Task Scheduler/third-party, not in the vba code.
Plus you would need to create a VBS file to run the code, and a .BAT file to run the excel file through the VBS file.
At least this is how I do it for a couple of years now.
Sounds complicated but it's not.
I have codes running every morning sending me various email alerts.
I used Task Scheduler but had some issues with it and then switched to a free third party program called "Schedule Manager".
Last edited by Mrrrr; 09-11-2020 at 03:32 AM.
To show your appreciation
Click ★ Add reputation!
Administrative Note:
We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
i really don't understand, 'Daily Run' in VBA Forum seems spot on in conveying that I would like to know if at all possible or how to go about creating a program that runs daily. I'm such a novice, I'll probably need help with coming up with a proper title if the one supplied is not correct. Furthermore, I thought the 'Title' was a short, sweet, and to the objective of the post, and the body of the post was to further elaborate on what I wish to do. But, I was educated in publik education in Arkansas, it just has to be known to forgive my trespasses for I know no better. ;-)
Mrrrr, I watched a video on your method, and goodness that looks complicated. but do-able.
Dominic, I'll look into on-time.
AliGW, I have no idea how to rephrase the title. VBA to run code daily? Scheduling VBA Code to run at set time?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks