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

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