Pause?
 

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

Pause?
 

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" wrote in message
news:cp7Xb.5543$m43.628@lakeread01...
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

Pause?
 

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

Pete



"Bob Phillips" wrote in message
...
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" wrote in message
news:cp7Xb.5543$m43.628@lakeread01...
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