Log In
Register
Home
April 2, 2020
Offline
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
See Answer
November 8, 2013
Offline
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
Offline
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 Bombea
1 Guest(s)
