Web Query Help Needed!

[Lagoon1]

Hi
Can someone please help out with web queries.

1. Are there any limitations on the type of data I import from the web. Even though I've set the import only html tables to false, it seems that the data that I am able to import is not what i would have expected

Example of a web site's data that I tried to import:
The following are saved as a web query file and extracted via Excel's web query function.

Web
1

http://www.nyse.com/listed/p1020656067970.html?displayPage=/listed/1020656067975.html

However, with no success.

Thanks.

Regards,

Lagoon1

 

[taupirho]

I don't know why your web query is not working. Does it work a simpler URL such as

http://www.amazon.com?

In any case, as an alternative try out the following macro code:-

workbooks.open filename:="

http://www.nyse.com/listed/p1020656067970.html?displayP..."

 

[Lagoon1]

Hi Tomreid
I've tried a few web site but with no success.

Any ideas?

Cheers,

Lagoon1

 

[PHV]

It's probably a frames issue.
Have you tried with this URL ?

http://www.nyse.com/listed/1020656067975.html

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Lagoon1]

Hi PHV
What do you mean by a frames issue? Very limited knowledge about this.

Can you please kindly explain and provide any resolution to overcome this frames issue.

Thanks.

Lagoon1

 

[PHV]

Have you tried to read the HTML source of the URL you want to grab ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Lagoon1]

Hi PHV
Yes, I have tried reading the html source of the URL that i tried to grab.

Up to the stage where there is a question mark, i reckon those would be the parameters?

Would there be any signs or symbols that might point it out or make it stand out?

Thanks.

Lagoon1