Hi I am in need of a way to scrape data from SharePoint URLs to an excel doc using a macro, VBA, or Access. Basically to make a long story short everyday I have to go to about 30 different SharePoint Urls and manually enter the report name, Date it was last updated, and the time it was updated. This is very time consuming. I normally use Access for most of my day to day but am familiar with excel macros and VBA. If anyone has a suggestion or knows how to scrape this data from the SharePoint's automatically that would be great if you could share. Thanks.

Jason