Using Application On Time to run Macro 1

[ADE6]

Hi ,

I am aware of the Application On Time method of running a macro at a set time of day.

Excel receives realtime data around the clock from another program via DDE links,about 10 seconds after every half hour I would like to run my macro.

Example times:

("21:30:10")
("22:00:10")
("22:30:10")
("23:00:10")


I was wondering if anybody had any ideas how to efficiently complete this task.

Thanks for the ideas

Ade

 

[WaterSprite]

Do not know if you still need this info. Chip Pearson has some of the best code I have seem to make a workbook run on a regular basis. Code is set to "pop" your workbook ever so many seconds. His site is easy to navigate, I think what you want is there under "onTime".