Cant Get data from a WEB Page

[Rachit Agarwal]

Hi,

I want to extrace a bit of data from a web paya thats
http://quotes.nasdaq.com/quote.dll?...&Leap=&mkttype=&sel=multi&userinput=&x=12&y=9
and I want the closing quotes of all the shares listed on the page but I
dont know hot to get this on excel automatically, Can any one help me.

Thanks,

Rachit
(e-mail address removed)

 

[Don Guillett]

I have done this often. The trick is to bring in the data using a web query
to a dummy page and then have a macro extract it to the final page desired.
I also suggest you use Yahoo due to the friendlier layout of the imported
table.

 

[Rachit Agarwal]

I dont know how to create a web query

Please help me

Rachit

 

[Don Guillett]

Goto HELP answer wizard>type in create a web query