Run code each half hour (12:00;00:30;01:00..23:00;23:30)

[Bishonen]

Hi all,

probably a very simple one for most of you. I'd like to run a code automatically each half hour. I know I have to put a workbook_open event first that redirects to the code and another line or two that will execute the code again and again.

Thanks

[wfm007]

Use:

Please Login or Register  to view this content.

[JasperD]

If you dont want it to run at a set time, but just every 30 mins after you opened the file and ran the code for the first time, then put the code below in your vba before the "end sub"

Please Login or Register  to view this content.

Please click the * below if this helps

[Bishonen]

Thanks guys. But is there a chance to make it work for every half and full hour during the day? I mean i could use the code given by wfm007 and expand it, but I'd like to avoid copying the same line 48 times.

Cheers!

[JasperD]

Hi Bishonen,

Let's assume your VBA is called "TEST"
So do as follows :

Please Login or Register  to view this content.

Please click the * below if this helps