Hi All
Scenario is as follows...PC is not setup to sync | or linked to OneDrive Account
Log into OneDrive Account
Open File in Excel via Desktop App
Checking if Path exists returns False...
The Path does exist as I am able to open the file called Test1.xls...
What am I missing...This is driving me crazy...Does FileSystemObject even support URL Paths?
Same posted here ...
Scenario is as follows...PC is not setup to sync | or linked to OneDrive Account
Log into OneDrive Account
Open File in Excel via Desktop App
VBA Code:
Sub CheckPath()
Dim Path As String
Path = ThisWorkbook.Path & "/March 2021"
' ! This returns.... https://d.docs.live.net/9c2e2efd643d32d1/Sawis Solution/March 2021
With CreateObject("Scripting.FileSystemObject")
If .FolderExists(Path) = False Then
MsgBox "THERE IS NO FOLDER TO PROCESS", vbInformation, ""
'Exit Sub
End If
End With
Workbooks.Open (Path & "/Orders/Test1.xls") ' This works...
End Sub
The Path does exist as I am able to open the file called Test1.xls...
What am I missing...This is driving me crazy...Does FileSystemObject even support URL Paths?
Same posted here ...