dynamacally creat multiple Web Query from a list

alap4381

New Member
Joined
Oct 9, 2008
Messages
2
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
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,122,216
Messages
5,594,886
Members
413,947
Latest member
gizmolucy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top