How to open a Sharepoint file on Excel with VBA

BERETTA Vincent 21 Reputation points
2020-06-18T07:15:15.953+00:00

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 :)

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
    2020-06-18T08:41:55.993+00:00

    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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful