How to open a Sharepoint file on Excel with VBA

BERETTA Vincent 21 Reputation points


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

LeSite = "" 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 :)

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,656 questions
0 comments No comments
{count} votes

Accepted answer
  1. Leon Laude 85,721 Reputation points


    Excel is currently not supported in the Q&A forums, the supported products are listed over here (more to be added later on).

    You can ask the experts in the dedicated Excel forum over here:

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

    Best regards,

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful