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
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

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
Back
Top