Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pause a macro | Excel Discussion (Misc queries) | |||
How do I pause a macro? | Excel Discussion (Misc queries) | |||
Macros Pause | Excel Discussion (Misc queries) | |||
Pause during a Macro | Excel Programming | |||
Pause a VBA Module | Excel Programming |