How to get the "local path" of excel file in sharepoint

[diego208]

Hi guys, I have a workbook in the sharepoint with the corp account, this file is synchronized with my PC, so the file has two paths, the local path (C:/users/files/sample.xlsm) and the web path (corp.sharepoint.com/sites/files/sample.xlsm).

If I used this sentence in vba "ThisWorkbook.Path" it gets the web path. Do you know any form to get the local path?, I need it

thanks for all!

[maniacb]

try

=CELL("filename")

[diego208]

I'm sorry It doesn't work :/ it gets the same path

[maniacb]

Have you been able to try to search your c drive for the file name?

[diego208]

I know where is the file in my pc, but I have a macro that copy any file in the same directory of the workbook, but now, that the file is in cloud, the macro doesn't work because it try to copy the files at the web path, and I want to copy those files in the local path for upload the info to sharepoint without going directly to the web. I know that I can drag the files to the folder and done but the macro help me a little more.
I can't put a fixed name of the path because I have to share the files with other people and when they sinchronized the sharepoint the local path is going to change.
Am I getting complicated with it?

[Marc L]

Hi,

if you find nothing in the VBA help of Workbook object properties - check it - then obviously
Excel knows only the path of the opened workbook so the answer seems not to be on Excel side …