Receiving Runtime error 1004 while importing from web

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a macro to import tables from a website. The call to add a
connection (with the approp info) is inside a loop to allow me to pull from
different tables on each iteration. After about ten cycles I get a runtime
error 1004 after the following code:
.Refresh BackgroundQuery:=False

On occasion I can step through this, while debugging, and it will make it.
But I can't seem to get past 10 or so cycles. Occasionally I will see the
error on the first cycle.

Any ideas what I'm doing wrong?
 
Back
Top