Opening Excel Macro File from OneDrive not synced with Local PC - Path Issue

[sintek]

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

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

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 ...

 

[diddi]

onedrive never worked for any of my projects, despite them working perfectly on local PCs including LANs

 

[sintek]

Thanks for response diddi...I also tried various URL Validity Functions...All return true even if such a folder does not exist...

Does this mean that the only way for VBA to work via OneDrive Web is to actually have it linked | synced to local Drive...?

 

[diddi]

yes thats what i did. i used a third party app to perform a sync on change. but the whole thing grinds to a halt and is unusable tbh

 

[sintek]

Client refuses to sync office pc's...All work is done through OneDrive 365 Cloud

 

[diddi]

bahaha its ****. i had one like that. they would not accept any advice and got some dude to convert everything to cloud based. and they had to pay of course... 3 months later when nothing worked they wanted me to build them a server. pffffft

 

[sintek]

No solution here...Time to convince client to sync OneDrive with local Drive...

 

[diddi]

syncing causes lag problems. i could not incorporate onedrive at all. it messed up everything

 

[sintek]

Anyone else with feedback...Other than negative lol....

 

[RoryA]

I can tell you that MkDir is not going to work for this.