I currently have Microsoft XML, v6.0 selected in references. I’m not clear on how to get to the data in the document using this parser in excel vba. Set xmlNode = xmlElement.SelectSingleNode("WorkflowTemplate") 'ENTER THE PATH WHERE THE XML Workflow DOCUMENT IS STORED:ĭocumentPath = InputBox("Enter the full path for the xml workflow document, example: C:\workflows\workflowseasy.xml", "Workflow XML File path", "C:\workflows\workflowseasy.xml") I’ve keep getting the error with this code: Dim xmlDoc As MSXML2.DOMDocumentĭim xmlAttribute As MSXML2.IXMLDOMAttribute I’m trying to use VBA to get to the value of all the Children’s names individually and get to the names of the arguments. The xml is well formed and looks like the following: I’ve found a plethora of examples, but none seem to be quite what I am looking for and I can’t seem to get past the error “Object variable or With block variable not set” I’m struggling with getting excel to parse through an xml file.
0 Comments
Leave a Reply. |