LinkBack URL
About LinkBacks
i want to run the macro called "collet" in these days and times
Monday at 11:00 PM
Wednesday at 7:00 AM
Friday at 3:00 PM
is there a way to program this? thank you
i want to run the macro called "collet" in these days and times
Monday at 11:00 PM
Wednesday at 7:00 AM
Friday at 3:00 PM
is there a way to program this? thank you
You probably want to use application.ontime this line of code below runs the macro "my_Procedure" at 5pm:
you can use if statements to determine whether that line gets run, thereby controlling the day.
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Try something like this
excel should be runningHTML Code:
Good luck,
Last edited by mokht; 06-10-2015 at 07:46 PM.
thanks but I could not get this to work..... I will try to be more clear. I want it so Monday at 11 pm I want the macro to run and the Wednesday at 7 am I want the macro to run and Friday at 3pm I want it to run.. not everyday at these times... thank you
the macro runs 3 times based on dates and times on code
it runs at : 2015, 6, 10 , 2015, 6, 20 and 2015, 6, 25 not everyday
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks