Monitoring sharepoint site using VBA

Damian37

Board Regular
Joined
Jun 9, 2014
Messages
227
Hello Everyone,
I was hoping there might be someone within this forum that has come across this issue before. I would like to set up some code to review a sharepoint site for the most current file that has been uploaded on to the site. The URL for the site is: https://comcastcorp.sharepoint.com/sites/XMSCSD/Forward%20Logistics/SitePages/Home.aspx?RootFolder=%2Fsites%2FXMSCSD%2FForward%20Logistics%2FShared%20Documents%2F14%20Day%20Report&FolderCTID=0x01200043A7813FCB2D9D46BD7A3CEE58056B7D&View=%7BC28CD63C%2DC6C8%2D4C83%2D944E%2D31420BF246C5%7D#InplviewHash1d0717f7-0a4c-43d4-bd8f-3ecd32f8ff10=FolderCTID%3D0x01200043A7813FCB2D9D46BD7A3CEE58056B7D-SortField%3DModified-SortDir%3DDesc
My questions are, would this URL be acceptable to use within my code in order to monitor for the most current file, and then open the file within an Excel file, and not open it up online? Please let me know if this made any sense, or if anyone has any questions concerning my post. Thank you.

Damian
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,100,139
Messages
5,472,747
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top