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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

diddi

Well-known Member
Joined
May 20, 2004
Messages
3,299
Office Version
  1. 2010
Platform
  1. Windows
onedrive never worked for any of my projects, despite them working perfectly on local PCs including LANs
 

sintek

New Member
Joined
Oct 14, 2015
Messages
39
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

Well-known Member
Joined
May 20, 2004
Messages
3,299
Office Version
  1. 2010
Platform
  1. Windows
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

New Member
Joined
Oct 14, 2015
Messages
39

ADVERTISEMENT

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

diddi

Well-known Member
Joined
May 20, 2004
Messages
3,299
Office Version
  1. 2010
Platform
  1. Windows
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

New Member
Joined
Oct 14, 2015
Messages
39

ADVERTISEMENT

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

diddi

Well-known Member
Joined
May 20, 2004
Messages
3,299
Office Version
  1. 2010
Platform
  1. Windows
syncing causes lag problems. i could not incorporate onedrive at all. it messed up everything
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,709
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
I can tell you that MkDir is not going to work for this. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,129,804
Messages
5,638,464
Members
417,025
Latest member
MusterDuster

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
Top