View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Importing data from the web (script page)

I just put in the url below and got the same
hcm.handelsbanken.se/struktureradeprodukter/kapitalskydd/Kurser/Aktieindexobligationer/"
hcm.handelsbanken.se/struktureradeprodukter/kapitalskyddKurser/Aktieindexobligationer

--
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,