Hi All,

I'm working on a macro which will download files from outlook to a folder on SharePoint mapped on my local machine.

At 1st step, I need to create a folder

ActiveWorkbook.Path is returning hyperlink path i.e. https://companyname-my.sharepoint.co...hna/documents/....

However, when I see the file location through file properties it shows as C:\Users\vinodkrishna\OneDrive\....

Could you please assist vba code to get file location as above instead of the hyperlink path?

Thanks,
Vinod Krishna