Pause?

  • Thread starter Thread starter Pete Fedrowitz
  • Start date Start date
P

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
 
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)
 
Back
Top