I have a series of WEB page addresses in a range cells(j, 2) and I need to loop through all of them to open each WEb page and copy the URL behind the text "DST Report". Moreover I need to paste the copied URL to Sheets("Data1").cells(j, 3)
Any help will be highly appreciated
Hi Mourad,
You have to analyze the web page and get the html element that stores that info, here is an article that explains the process:
https://www.myonlinetraininghub.com/web-scraping-with-vba
Thank you so much Catalin for your valuable advise. The article is really super excellent and I have to extend my thanks to Mynda for her attached workbook. I have to admit
the workbook was very helpful and saved a lot of my time
Wish you and Mynda the best of luck now and always in 2023 and beyond