List documents in SharePoint Office 365

[CDexel2011]

I am trying extract a list of documents from SharePoint Office 365. The below code works for searching my pc, but is there any VBA that would allow searching of a SharePoint site?

Please Login or Register  to view this content.

Hoping a wizard can advise.

[JEC.]

Definitely go for Power Query in this case

[CDexel2011]

Thanks JEC,

Do you have a suggestion of how to structure that query?

[JEC.]

Get data —> from sharepoint site. The following steps are just a few clicks in the query editor. If you have worked with power query before it’s simple.

See this link

https://support.cloudextend.io/en/ar...ry-or-power-bi

[CDexel2011]

I have indeed, I will give it a go.