Web Query in VBA

[Mr.FutureCoder]

HI,

What i am trying to do is i am downloading the data to excel sheet from below mentioned website for the company from different tabs mentioned on the website i.e :License Details , Addresses, Responsible officers and so on. There are 1200 companies for which i want to download the data. PLease someone tells me the fastest way to do it in VBA.

Thanks.

http://www.sfc.hk/sfcprd/eng/pr/html/Corp_Details.jsp?charset=ISO8859_1&ceref=ABI440&applNo=0002

p.s.- only ceref will change for other companies and for the tab only "Corp_Details" will change.

 

[Mr.FutureCoder]

To add further i have ceref in one column of the sheets for all the companies in front of the name cell of the company.