I am using this code to retrieve data, but it gives me an error on th
"Refresh" line.

Error - "Run-time error '1004': Method 'Refresh' of objec
"_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

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/

There's no problem with the connection. The URL works perfectly for the
PC. It's just the Mac giving me problems. It works on smaller datas.


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