Problem with Importing Data to Spreadsheet

Posted to microsoft.public.excel.programming

kenji4861[_5_] kenji4861[_5_] is offline

external usenet poster

Posts: 1

Problem with Importing Data to Spreadsheet

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing Data from a pre-existing spreadsheet	Todd Helmick	Excel Discussion (Misc queries)	2	July 23rd 09 01:13 PM
Problem importing from Google Spreadsheet	christophercbrewster via OfficeKB.com	Excel Discussion (Misc queries)	2	March 27th 09 03:59 PM
Importing data from another spreadsheet to a different format	Cam Buskell	Excel Discussion (Misc queries)	0	July 3rd 08 10:10 PM
Importing data, then adding data to the new spreadsheet.. a conund	AndyL82	Excel Discussion (Misc queries)	1	March 9th 06 10:05 PM
Importing Data From Another Spreadsheet	Tiziano	Excel Discussion (Misc queries)	6	January 7th 05 02:35 AM

All times are GMT +1. The time now is 06:01 AM.

Menu

About Us