Hi ws,
This may help get you started. The code is from: http://www.ozgrid.com/Excel/run-macro-on-time.htm
You'll find other examples if you google "VBA ontime"
The code is in the Workbook_Open event and a standard module as explained in the link above. In my example it is set to 30 seconds.
Cheers,
dr
Cheers,
dr