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.