Pause?

[Pete Fedrowitz]

Is there a command to pause a subroutine? Specifically, I try to read data
from a web-page that I have just Refreshed:

Selection.QueryTable.Refresh BackgroundQuery:=False

When the sub bombs at this command, I manually wait a minute or two and try
again and most of the time that works. I want to write an "on error" that
will automatically wait a minute and then try again.

Thanks

 

[Bob Phillips]

Pete,

Take a look at the Wait method in VBA Help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Pete Fedrowitz]

Thanks, Bob. It's just what I've been looking for.

Pete