Application.ontime to stop at a certain time

[rey745]

Hello All


This is my first post, this website has helped my many times. I have a code that i need emailed out every 30min and it is currently working fine it updates my worksheets and them pastes data into an email and sends it out. The problem is i cant get it to stop. I have another VBA that creates a query to a download link and then i just have to refresh all to update data. The link for the query only stays active for 24hrs so i have to change it everyday and then run the VBA to start the emails. The code is posted below i just need the emails to stop sending at 11:59pm on the day it is started or have it set only to run a certain amount of times and then stop. Any help would be greatly appreciated code is pasted below

Please Login or Register  to view this content.

Thank you

[mrice]

You could try

Please Login or Register  to view this content.

Which should end the loop close to midnight.

[mehmetcik]

Try adding this to the bottom of your code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[rey745]

Thank you so much for the quick response i will try now and let you know in the morning

[rey745]

they both worked thank you very much!!