Automatic execution of macro

  • Thread starter Thread starter =?iso-8859-1?q?Paul-Andr=E9_Gollier?=
  • Start date Start date
?

=?iso-8859-1?q?Paul-Andr=E9_Gollier?=

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)
 
Back
Top