Macro in Office 365 Excel
We are trying to troubleshoot an issue for one of our clients in which we developed an excel macro to populate a copy of an excel workbook onto their sharepoint website. Their macro stopped functioning and keep getting an Access denied error below:
Const spBASE_URL = https://mycompany365.sharepoint.com/sites/Test/ 'Your sharepoint site
Const spDOC_LIB = "Documents" 'Your sharepoint library name plus your folder name (if required)
Const spCONTENT_TYPE = "0x000000000000000000000000000000000000000"
Here is snippet of some of the pertinent macro. we was wondering if you know why we would be getting the access denied error and if there is workaround?
'Perform the upload
Dim ObjectStream, ObjectDOM, ObjectElement, ObjectHTTP As Object
Dim BinaryFile, EncodedFile, strurlservice, strsoapaction As String
Set ObjectStream = CreateObject("ADODB.Stream")
Set ObjectDOM = CreateObject("Microsoft.XMLDOM")
Set ObjectElement = ObjectDOM.createElement("TMP")
Set ObjectHTTP = CreateObject("Microsoft.XMLHTTP")
ObjectHTTP.Open "Get", strurlservice, False
ObjectHTTP.SetRequestHeader "Content-Type", "text/xml; charset=utf-8"
ObjectHTTP.SetRequestHeader "SOAPAction", strsoapaction
We are wondering if Macro is support or not support for Online Excel Macro and office document from MS to indicate support/not support Macro.
Sign in to comment