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

sintek

New Member
Joined
Oct 14, 2015
Messages
39
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
File-Copy-icon.png

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

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
onedrive never worked for any of my projects, despite them working perfectly on local PCs including LANs
 
Upvote 0
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...?
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
syncing causes lag problems. i could not incorporate onedrive at all. it messed up everything
 
Upvote 0
I can tell you that MkDir is not going to work for this. :)
 
Upvote 0

Forum statistics

Threads
1,223,910
Messages
6,175,318
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top