timer

I am using a query to retrieve data from the Internet and need to build in a
timer to wait for the remote server to reset. Can someone please help with a
few lines of code to wait for say a 10 min. interval? Many thanks.

try

Application.Wait Now + TimeValue("00:10:00")



"Mike Macgowan" wrote:

> I am using a query to retrieve data from the Internet and need to build in a
> timer to wait for the remote server to reset. Can someone please help with a
> few lines of code to wait for say a 10 min. interval? Many thanks.
>
>
>

awesome. thanks. my help files need to be reinstalled so I was dead in the
water.

"duane" <[email protected]> wrote in message
news:[email protected]...
> try
>
> Application.Wait Now + TimeValue("00:10:00")
>
>
>
> "Mike Macgowan" wrote:
>
> > I am using a query to retrieve data from the Internet and need to build
in a
> > timer to wait for the remote server to reset. Can someone please help
with a
> > few lines of code to wait for say a 10 min. interval? Many thanks.
> >
> >
> >

Take a look here:

http://cpearson.com/excel/ontime.htm


In article <#[email protected]>,
"Mike Macgowan" <[email protected]> wrote:

> I am using a query to retrieve data from the Internet and need to build in a
> timer to wait for the remote server to reset. Can someone please help with a
> few lines of code to wait for say a 10 min. interval? Many thanks.

This isn't really designed for 10 minute intervals, but here's a solution
that adds a vb like timer control.

http://www.enhanceddatasystems.com/E...ExcelTimer.htm

Robin Hammond
www.enhanceddatasystems.com

"Mike Macgowan" <[email protected]> wrote in message
news:%[email protected]...
>I am using a query to retrieve data from the Internet and need to build in
>a
> timer to wait for the remote server to reset. Can someone please help with
> a
> few lines of code to wait for say a 10 min. interval? Many thanks.
>
>