Importing data from the web (script page)
 

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...ml+document%2e

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

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

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 -

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,