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