Notifications
Clear all
Topic starter
Hello All,
I have this URL and I wan to extract all companies name and it's URLs from all pages 1, 2,.....
Could you please help me to do this by Macro.
https://www.marketscreener.com/stock-exchange/sectors/World-99/Telecommunications_Services-58/
https://www.marketscreener.com/stock-exchange/sectors/World-99/Consumer_Cyclical-53/
Thanks;
Ehab
Posted : 14/05/2019 10:38 am
Hello,
Have you tried using Power Query? https://www.myonlinetraininghub.com/get-data-from-the-web-with-power-query
Here is a good article how to use VBA to get data from web pages. https://www.myonlinetraininghub.com/web-scraping-with-vba
Posted : 17/05/2019 12:20 am
Hi Ehab,
I just wrote an article that may help
https://www.myonlinetraininghub.com/web-scraping-filling-forms
Regards
Phil
Posted : 31/05/2019 6:51 am
Topic starter
Thank you very much!
Posted : 03/06/2019 3:47 pm
