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.

Take a look he

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


In article ,
"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" wrote in message
...
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.

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" wrote in message
...
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.