dynamacally creat multiple Web Query from a list

[alap4381]

I need to extract data from web to analyse financial performence of various companies for trading stock. The web address is http://www.dse.com.bd/company_details.php?name=AFTABAUTO, please notice that I need to change the last part of the web address to get data of other companies, for example http://www.dse.com.bd/company_details.php?name=GP. Is it possible to change the web query address from a list that contains the company name like AFTABAUTO or GP etc? I also need to rearrange the data by coping required data to a separate worksheet, at present I am doing it by copy and paste special to another page which is extremely time consuming. I need to get data from around 500 pages. My ultimate aim is to get those data to a MS Access database for further analysis. I don't have much knowledge on VBA, please suggest a solution considering my limited knowledge on VBA............thanks

 

[stingraysvt]

Did you ever figure out how to do this?