Extracting web page title and date modified from a URL in Excel

henry516

New Member
Joined
Feb 15, 2022
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
  2. Web
Hello!

I’m looking for some help because I’ve been stuck on this issue for quite some time and haven’t been able to fully find an answer online… So any help is extremely appreciated!!

I have about 1500 URLs from the same web page in an Excel sheet and I need help with the coding in VBA to be able to extract both the title of the page and at the bottom of each web page there is a ‘date modified’ - I’m hoping to extract that as well.

Also, I have another question, is it possible to run code in Excel to be able to see all the tracked modified changes throughout a web page (almost like an audit of each webpage) just to see dates it was updated.

Let me know if this is possible, any help is super appreciated!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,223,884
Messages
6,175,174
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top