Share via

How to open a Sharepoint file on Excel with VBA

Anonymous
2020-06-18T08:49:56+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 did not found. How could I do ?

Thank you all :)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-06-23T06:07:45+00:00

    Hi Gloria,

    No worries for the delay.

    How can I transfer this thread to the programming category ?

    0 comments