Help with ActiveSheet.QueryTables.Add Connection:

C

chintu4u

Joined
Apr 30, 2006
Messages
1
Reaction score
0
Hi I want to import data from website. wht the problem is for first time the code run sucessfully but for second time it gives error at :
, Destination:=Range("A1"))

Error Description : Method 'Range' of object '_Global' failed. i.e
Run Time Error 1004.

wht I m doing is I have a list of argument every time it take one argument frm list then it goes to internet collect data from website and paste in Excel sheet then I transfer tht data to Access and clear the Excel sheet and save it after that it takes second argument and goes to internet at this time it gives above mentioned error..

Please help me with the same..
 
You must log in or register to reply here.

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

Not working... Why? ActiveSheet.QueryTables.Add(Connection:=ActiveCell.Offset(0, 2
ActiveSheet.QueryTables.Add using InputBox and/or a URL list in a .txt file list 4
Simple Copy Paste within Worksheet Change Event 2
Excel Run-time error '1004' General ODBC Error 1
help with ActiveSheet.QueryTables.Add Connection: 1
Open an excel-file from the web 3
Assembling large "array" 3
Error values generated in functions 1

Back
Top