VBA Get File Path of Active Workbook as String without a URL

[Temelan]

When I use ThisWorkbook.path I get back a URL (https://...) instead of a file path (C:\...). How do I use VBA to get the local file path? For context, the workbook I'm using is saved in my OneDrive folder.

 

[Marc L]

​

So obviously open the workbook from the local drive rather than from OneDrive …​

 

[Temelan]

​

So obviously open the workbook from the local drive rather than from OneDrive …​

Ok... so I moved the workbook out of my OneDrive folder and ThisWorkbook.path functions correctly. Why is it that it doesn't work when the file is in the OneDrive folder? Does anyone know of a Sub that gets the local path of a workbook in the OneDrive folder?

 

[Alex Blakenburg]

Try the function posted by MatChrupczalski on the msdn forum here > how to get physical path instead of URL (OneDrive)

Once you are on the webpage either search for his name and scroll up or search for his opening line which is:
"In case your OneDrive folder is not in default location, the code below will allow you to locate the file wherever it is."

I don't currently have access to Sharepoint but I think it might work for that too.

 

[JustinY]

If your file path is always the same, you could use something like this:

Environ$("userprofile") & "\[OneDrive Folder Name]\Folder\Subfolder\etc.\"

This works for me. I have three OneDrives (2 for different employers and a personal one), so I need to identify the name of the OneDrive folder. I think you could use something like this if you only have a single OneDrive:

Environ$("OneDrive") & "\Folder\Subfolder\etc.\"

Alternatively, you can turn off automatic syncing while running the macro, which should allow ThisWorkbook.Path to function normally.