Generally I believe this is an indication there is a problem with your
connection/connection string.

--
Regards,
Tom Ogilvy

"kenji4861 " wrote in message
...
I am using this code to retrieve data, but it gives me an error on the
"Refresh" line.

Error - "Run-time error '1004': Method 'Refresh' of object
"_QueryTable" failed.

---------------------------
With Sheet1.QueryTables.Add(Connection:= _
"URL;" + dataWebsiteString, _
Destination:=Range("A1"))
BackgroundQuery = True
TablesOnlyFromHTML = True
Refresh BackgroundQuery:=False
SaveData = True
End With
---------------------------

The code seems to work for shorter data, but long datas don't work.
Thanks for any help!


---
Message posted from http://www.ExcelForum.com/