<div>
This post has not been updated in 2 weeks and has been classified as abandoned.
</div>


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

<div>
<div class="content wysiwyg-content">
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 &nbsp;without having to use authentication. Im already logd in With my Office Applications.<br />
Can anyone help me? <br />
<br />
Im using Office 365, 2016 an Sharepoint online. I am a administrator.
</div>
</div>


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.

Sharepoint and VBA

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Representational state transfer (REST) is an architectural style that gives a coordinated set of constraints to the design of components in a distributed hypermedia system used to design networked applications. RESTful systems typically communicate over Hypertext Transfer Protocol (HTTP) with the same HTTP verbs (GET, POST, PUT, DELETE, etc.) that web browsers use to retrieve web pages and to send data to remote servers. REST interfaces with external systems using resources identified by Uniform Resource Identifier (URI) that can be operated upon using standard verbs.

REST

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.