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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
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)