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
Bookmarks