There is a nice webquery on this thread ..
http://www.excelforum.com/excel-prog...heet-help.html
Can this code be customized to download data from this website ??
http://economictimes.indiatimes.com/...nyid-10960.cms
http://economictimes.indiatimes.com/...nyid-11822.cms
I want to download data for few 100 companies .. i will make a list of company names and companyid's in two columns .. can a Macro pick these two fields generate an url and download the table into excel??
Also, can it be set up to save the data in another excel?
It generates
Please help ..
Bookmarks