View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Automatic execution of macro

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