I need Excel VBA code to open workbooks that are in a SharePoint location

Question

I need Excel VBA code to open workbooks that are in a SharePoint location...

I am comfortable with Workbooks.Open and using an old 'mapped' address such as T:\documents\TestFile.xlsx

How can I work out the SharePoint address of a file in a format that I will be able to use in VBAcode?

Thank you

Answer 1

Dear mjxhx,

Good day!

Thank you for posting to Microsoft Community. We are glad to assist. We are looking into your situation, and we will update the thread shortly.

Appreciate your patience and understanding and thank for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 2

How to open SharePoint File from one Excel Workbook and then edit opened file using VBA | MrExcel Message Board

Sub aa()

Dim wb As Workbook

Set wb = Application.Workbooks.Open("https://domain.sharepoint.com/sites/Folder/Shared%20Documents/Test/Test.xlsx")

End Sub

Answer 3

Thanks - that's reassuring, but I'm not yet a SharePoint user... where do I find that SharePoint address...

"https://domain.sharepoint.com/sites/Folder/Shared%20Documents/Test/Test.xlsx"

is it in the SaveAs dialog? or in the title-bar of the Application? or is there somewhere else I can read or copy it?

Thanks

Answer 4

On Sharepoint>Open details>Then you can find the path of that file and copy it.