Web download to MS Excel

Question

Hello All:

I am pretty computer illiterate so please excuse my ignorance

I am trying to download data from a particular website in MS Excel. Web link is: http://www.nseindia.com/marketinfo/companyinfo/eod/Shareholding/shareholding%5Fmain%5Faft%5F31Mar09.jsp?nds%5Fid=15836&symbol=HDFC&count%5Fstring=0%7C12%7C0%7C0%7C0%7C0%7C0%7C2%7C6%7C0%7C0%7C0%7C0%7C0%7C&as%5Fon%5Fdt=30-SEP-2009

Trying to do this for approximately 500 companies (determined by symbol – HDFC in above string) on a quarterly basis, and would appreciate if somebody could assist in suggesting a method.

Thanks in advance.

Regards

Answer 1

Enter "web query" in the Excel help window. I hope that's what you're looking for.