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" <duane@discussions.microsoft.com> wrote in message
news:9DA47260-0850-4FA7-AD32-C0F44AED5A64@microsoft.com...
> 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 <#Ra3kqnXFHA.2520@TK2MSFTNGP09.phx.gbl>,
"Mike Macgowan" <mmacgowa@yahoo.com> 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" <mmacgowa@yahoo.com> wrote in message
news:%23Ra3kqnXFHA.2520@TK2MSFTNGP09.phx.gbl...
>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.
>
>