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

 

[Jaffey]

you might have better luck in the VBA forum