Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Paul-Andre,
Take a look at OnTime method in VBA Help. You can schedule a macro to run at a set time, or an amount of time from now. In your situation, the macro would re-issue the OnTime command after it has done its real work. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Paul-André Gollier" wrote in message ... In a realtime acquisition, I'd like to execute a macro periodically. This macro insert cells and copies the data wich is in cells linked to an automate (TCP/IP controled by another program I don't have access to) Any idea to execute a macro around every minutes would be welcome. Thnak you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AUTOMATIC EXECUTION | Excel Discussion (Misc queries) | |||
Macro Execution | Excel Discussion (Misc queries) | |||
How to automatic calculation and macro execution between 3 workbooks? | Excel Worksheet Functions | |||
automatic macro execution | Excel Programming |