Sharepoint and VBA

langemyr
langemyr used Ask the Experts™
on
I'm starting Word and Excel templates from New menu as a content type in a document libary and vant to use VBA to Query som SharePoint list. I have read some about ListData.svc and get some Nice resuts. i have read some about the REST API and MSXML2.XMLHTTP60 but is this possible to  without having to use authentication. Im already logd in With my Office Applications.
Can anyone help me?

Im using Office 365, 2016 an Sharepoint online. I am a administrator.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT System Administrator
Distinguished Expert 2017
Commented:
I'm not sure about using REST API, but here are a couple of links that might help:
Excel Geeking: Using VBA And ADO To Pull Data From SharePoint Lists
HOW TO USE MICROSOFT EXCEL TO QUERY A SHAREPOINT LIST
Mike in ITIT System Administrator
Distinguished Expert 2017

Commented:
This post has not been updated in 2 weeks and has been classified as abandoned.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial