Receiving Runtime error 1004 while importing from web

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 1004 when trying to insert formula in cells 11
Run Time Error 1004 with Excel Web Query Macro 0
runtime error 1004 HELP PLS 2
QueryDef; Error 1004 1
Runtime Error 1004 5
debug runtime error 1004 2
Run-time Error 1004 - retry x times or end 3
VBA runtime error 1004; Method of 'open' of object 'workbooks' failed 1

Top