Forum

Get a Url from a WE...
 
Notifications
Clear all

Get a Url from a WEB page

3 Posts
2 Users
0 Reactions
73 Views
(@mbw00001)
Posts: 6
Active Member
Topic starter
 

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

 
Posted : 11/01/2023 5:55 am
(@catalinb)
Posts: 1937
Member Admin
 

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

 
Posted : 13/01/2023 1:56 am
(@mbw00001)
Posts: 6
Active Member
Topic starter
 

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

 
Posted : 14/01/2023 12:45 am
Share: