Run-time Error 1004 - retry x times or end
 

Hi - am using the following querytable code to retrive data from a internet
site into excel where qurl is my webaddress.

With DataSheet.QueryTables.Add(Connection:="URL;" & qurl,
Destination:=DataSheet.Range(qStart))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With

'Sometimes' I get Run-time error 1004. Unable to open (i.e. the aurl I have
specified). I know the link I have specified is valid, just that it fails
sometimes as if i continue from the break, it will complete after a retry or
2.

Can I somehow trap Error Code 1004 so that I can retry x times (say 5
times). If this fails, then end the sub-routine and run msgbox("The link is
currebtly unavailalbe").

This sounds logical to me, but I got no idea how to program it.
Bruce

Run-time Error 1004 - retry x times or end
 

Try On Error Resume Next before your query code to stop the error from
halting the code.

Mike F
"Bruce" wrote in message
...
Hi - am using the following querytable code to retrive data from a
internet
site into excel where qurl is my webaddress.

With DataSheet.QueryTables.Add(Connection:="URL;" & qurl,
Destination:=DataSheet.Range(qStart))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With

'Sometimes' I get Run-time error 1004. Unable to open (i.e. the aurl I
have
specified). I know the link I have specified is valid, just that it fails
sometimes as if i continue from the break, it will complete after a retry
or
2.

Can I somehow trap Error Code 1004 so that I can retry x times (say 5
times). If this fails, then end the sub-routine and run msgbox("The link
is
currebtly unavailalbe").

This sounds logical to me, but I got no idea how to program it.
Bruce

Run-time Error 1004 - retry x times or end
 

Thnak Mike - 2 questions

1. Do i put this line before my code?

2. qurl is an erray element. Will resume make it skip this element or retry
the one that caused the code to halt (as I want it to retry x times and then
exit if it fails?

Bruce

"Mike Fogleman" wrote:

Try On Error Resume Next before your query code to stop the error from
halting the code.

Mike F
"Bruce" wrote in message
...
Hi - am using the following querytable code to retrive data from a
internet
site into excel where qurl is my webaddress.

With DataSheet.QueryTables.Add(Connection:="URL;" & qurl,
Destination:=DataSheet.Range(qStart))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With

'Sometimes' I get Run-time error 1004. Unable to open (i.e. the aurl I
have
specified). I know the link I have specified is valid, just that it fails
sometimes as if i continue from the break, it will complete after a retry
or
2.

Can I somehow trap Error Code 1004 so that I can retry x times (say 5
times). If this fails, then end the sub-routine and run msgbox("The link
is
currebtly unavailalbe").

This sounds logical to me, but I got no idea how to program it.
Bruce