Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing data from the web (script page)
On Mar 18, 8:02*pm, "Don Guillett" wrote:
*finally got your url to go in the macro but got this error. Sorry I can't be of further help. http://www.google.com/search?sourcei...=UTF-8&rlz=1T4... -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message news:... I just put in the url below and got the same hcm.handelsbanken.se/struktureradeprodukter/kapitalskydd/Kurser/Aktieindexo*bligationer/" hcm.handelsbanken.se/struktureradeprodukter/kapitalskyddKurser/Aktieindexob*ligationer -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... I gave you the method to do this. Surely you can paste in the correct url and re-do or contact me for custom work. -- Don Guillett Microsoft MVP Excel SalesAid Software "Wesslan" wrote in message .... Don, Many thanks for your quick reply! It does exactly what I am asking for (but for some reason) the link in my first post was incorrect. The page from which I want to pull the data is "http:// hcm.handelsbanken.se/struktureradeprodukter/kapitalskydd/ Kurser/Aktieindexobligationer/" (please observe the /Kurser/ Aktieindexobligationer) So is it possible to do the same but for that page? Cause if I understand your code correctly you take the first webtable and pull that data out (which is perfect for the "http://hcm.handelsbanken.se/ struktureradeprodukter/kapitalskydd/" but not for the link I actually wanted (apologize for that the link somehow became broken in the first message). If you have a solution for this you will make my day! In the meantime, I will play around with the WebTables and see if any number works for the link.. ;) Regards,- Hide quoted text - - Show quoted text - Hehe Don, it's alright. That's the same error I have been struggling with all day ;) But if there is a will, there is a way. I will continue to look for a solution and if I find one, I will send it to you! Best regards, Peder |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing data from the web (script page)
I go to that webpage and get "Internet Explorer cannot display the
webpage" every time. --JP On Mar 18, 4:09*pm, Wesslan wrote: Hehe Don, it's alright. That's the same error I have been struggling with all day ;) But if there is a will, there is a way. I will continue to look for a solution and if I find one, I will send it to you! Best regards, Peder- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing data from the web (script page)
JP,
Thanks for your reply. The problem is that the link seems to long for this webpage. It is: http://hcm.handelsbanken.se/struktur...exobligationer I will also break it down into three components which can be concatenated so that the entire link is part of it. 1. http://hcm.handelsbanken.se/ 2. struktureradeprodukter/kapitalskydd/ 3. Kurser/Aktieindexobligationer Can you obtain the data from automatically from the table in the middle? Best regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data from the web (script page) | Excel Programming | |||
Importing Data Into Excel From LONG Web Page With URL Ending With .cfm | Excel Worksheet Functions | |||
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 |