How to extract the original URL of a web page that has been saved in desktop using VBA

Sanmrxl

New Member
Joined
Aug 1, 2007
Messages
33
I have been saving some webpages in a folder on my desktop. The path of this file (the saved webpage in IE) will now be the local folder address. To find the orginal site from which this page was downloaded, this info is available in the "View Source" under
the '< meta property="og:url" content=" <<ORIGINAL SITE ADDRESS>>"
Is there a way to get this data "ORIGINAL SITE ADDRESS" into an XL sheet.
 
Last edited:

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Sanmrxl

New Member
Joined
Aug 1, 2007
Messages
33
Info for more clarity:
the text that is wanted is the Original Site Address that is here in this tag in the source code.
'< meta property="og:url" content="ORIGINAL SITE ADDRESS"

The macro I wish should be able to take input as the local path of the saved web page and
the output should be the ORIGINAL SITE ADDRESS, in an XL sheet
for all the list of web pages.

Hope the question is clearer now.
THANKS in advance for your help
 

Sanmrxl

New Member
Joined
Aug 1, 2007
Messages
33
Hello ..with no replies.. I am not sure, if this is a tough nut to crack, or have I missed to give some details.
Request the MVPs and other seniors in this group to respond.
Have been struggling with this for 2 days now.
Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,268
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top