question

BERETTAVincent-0380 avatar image
0 Votes"
BERETTAVincent-0380 asked ·

How to open a Sharepoint file on Excel with VBA

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-supported
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LeonLaude avatar image
1 Vote"
LeonLaude answered ·

Hi,

Excel is currently not supported in the Q&A forums, the supported products are listed over here https://docs.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

· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Leon,

Thank you for the answer, I did not know. I will ask on the appropriate forum.

Thanks again :)

0 Votes 0 ·
LeonLaude avatar image LeonLaude BERETTAVincent-0380 ·

No worries, you're welcome!

1 Vote 1 ·