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

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

Please Login or Register  to view this content.

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?
I also tried various URL Validity Functions...All return true even if such a folder does not exist...

Same posted here

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

Or...holding thumbs...has someone have a solution...

I just get in VBA, I don't know much but I think FileSystemObject doesn't support URL path.

Maybe change URL path to Local path before check

Please Login or Register  to view this content.

Hi Bo_Ry

Thanks for response...I had a previous thread solved by this...
Problem is...OneDrive is not linked | synced to any Local Drive...Cloud access only...

Just some thought,
I tried Evaluate but it always gives an error.
Evaluate("='" & fPath & "Sheet1'!A1")

I need to put the formula to the cell.
[Z1].Formula = "='" & fPath & "Sheet1'!A1"

Please Login or Register  to view this content.

Thanks Bo_Ry

The issue is not opening files that exist..the issue is checking for folders and also if not to MkDir...This just does not seem possible with OneDrive URL...

I don't know how to check OneDrive URL folder exists.

But if the file in that folder exists, that means the folder exists.

Code in #4 checks if the file in that folder exists without open the file.

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