

April 2, 2020

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


November 8, 2013

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.myonlinetraininghu.....g-with-vba


April 2, 2020

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

Answers Post
The following users say thank you to Mourad Wassef for this useful post:
Catalin Bombea1 Guest(s)
