Hello,
I have opened an excel file from OneDrive.
The
Application.ActiveWorkbook.path
Command, returns a string like:
https://Company-my.sharepoint.com/pe...s/JOBS/Current Job

however, if click to do a “Save As” (Excel 2016) than, I see in the “Save As” window that the File Location is :
C:\Users\Me\OneDrive - Company\JOBS\Current Job

How can I get the “C:\Users\Me\OneDrive - Company\JOBS\Current Job” displayed in a message box ?

Thanks