Downloading most recent file in sharepoint site

[Damian37]

Hello all,
I've managed to create code that will open a specific sharepoint site, however, I'm now attempting to open the most recent file unsuccessfully. I was hoping someone may have in to this situation before. Here;'s the code to open the site:

Sub sbVBA_To_Open_Website_URL_FollowHypderlink()
    Dim strURL As String
    strURL = "https://comcastcorp.sharepoint.com/sites/XMSC/Shared%20Documents/Forms/AllItems.aspx?RootFolder=%2Fsites%2FXMSC%2FShared%20Documents%2FXPO%20Reporting%2FComcast%2FHourly%20Inventory%20On%20Hands&FolderCTID=0x01200030B083755A4E5A49946BDA920EC6FE37"
    ThisWorkbook.FollowHyperlink (strURL)
End Sub

Now that I have to site open I would like to download the most recent in order to manipulate it to suit my needs? Thanks for any help anyone can give me.


D.

 

[Damian37]

Can anyone tell me why the first two lines of this code are red:

Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, _
    ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long

Function DownloadFileFromWeb(strURL As String, strSavePath As String) As Long
    ' strSavePath includes filename
    DownloadFileFromWeb = URLDownloadToFile(0, strURL, strSavePath, 0, 0)
End Function

The code looks normal on this forum, however within the developer page shows the Private Declare Function thru to As Long, _ as red. Any ideas?

Thank you