Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing data from the web (script page)
Hi,
I have spent most of today reading different threads on the matter of pulling data from the web to Excel. Many use the approach of opening an IE window and then copying all data into Excel. Others use web query through Excel and specify which table they would like to download. As I have understood it the IE approach is useful if the page is of HTML or similar format with frames etc. But the page I want to pull data from is not a straightforward page but rather is a script page. I therefore tried the Web query which Excel provides and then managed to get the table I want (in the query request) but when Excel is to import the data I get the message "Only one top level element is allowed in an XML document". The page I want to download data from is the following: "http://hcm.handelsbanken.se/struktureradeprodukter/kapitalskydd/ Kurser/Aktieindexobligationer/" and I would like to pull the data which is presented in the middle of it (SHBO 1003.. SHBO 1004 and so on).. Any guesses on how I could do this (automatically of course :)? Many thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data Into Excel From LONG Web Page With URL Ending With .cfm | Excel Worksheet Functions | |||
Importing From web page | Excel Discussion (Misc queries) | |||
Importing Data - Macro or Script | Excel Worksheet Functions | |||
Importing checkbox data from web page | Excel Discussion (Misc queries) | |||
an error has occurred in the script of this page | New Users to Excel |