How to open a Sharepoint file on Excel with VBA

Question

Hi,

I would like to open an Excel file that is on our Sharepoint.
I tried this code:

LeSite = "https://sharepoint.com/:x:/r/sites/xxxxxThenamexxxx.xlsm?d=wea5d3e23c3754266ab5948e0a7b226d4&csf=1&web=1&e=FFvezQ" ActiveWorkbook.FollowHyperlink Address:=LeSite

But it opens on the webpage of SharePoint (Google Chrome) and I would like to open it on the Excel application.

Then, I tried a code that I found online but it downloaded it.

I searched for an answer online but didn't found.
How could I do ?

Thank you all :)

Answer 1

Hi,

Excel is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can ask the experts in the dedicated Excel forum over here:
https://social.technet.microsoft.com/Forums/en-US/home?forum=excel

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel

(Please don't forget to accept helpful replies as answer)

Best regards,
Leon