Open Latest File from SharePoint|VBA & Macros|Excel Forum|My Online Training Hub

Hi, I use the below code, to open the latest file from a folder or subfolder. Works great, easy to adapt to different folder situations and file name components.

But the MyFile step throws an error if I want to use it for a SharePoint folder. [Bad file name or number]

Google gave me two possible reasons in regard to the path: "/" and "https:"
I can change one or both of them, but it does not change the error on the MyFile step. So I commented it out here.

Where is my mistake? Is there any other adaptation necessary? Or is there an alternative approach available? Thanks!

'find & open latest XYZ File
Dim MyPath As String
Dim MyFile As String
Dim LatestFile As String
Dim LatestDate As Date
Dim LMD As Date

MyPath = "https://company.sharepoint.com/blah/abcd/Team Documents/whatever/details/2021/"
'MyPath = Replace(MyPath, "/", "\")        'adaptation attempt for SharePoint folder
'MyPath = Replace(MyPath, "https:", "")  'adaptation attempt for SharePoint folder
MyFile = Dir(MyPath & "XYZ *.xlsm")

If Len(MyFile) = 0 Then
MsgBox "No XYZ files were found...", vbExclamation
Exit Sub
End If

Do While Len(MyFile) > 0
LMD = FileDateTime(MyPath & MyFile)
If LMD > LatestDate Then
LatestFile = MyFile
LatestDate = LMD
End If
MyFile = Dir
Loop

Workbooks.Open MyPath & LatestFile