What is syntax for Namespace object in VBA?

By william.beissel ·
I have been tasked with parsing a rather large XML file. It contains certain data within its elements that I need to display on an Access Project form. I am having great difficulty getting the correct code / snytax to set the file's NameSpace and 'MakeTable' objects and properties. Can anyone provide some assistance / samples on how this can be done, again in VBA, not VB? A sample of what I have so far is, but of course is not correct.

Dim varString As String, varStringB As String
Dim doc As MSXML2.DOMDocument
Set doc = New MSXML2.DOMDocument

'Doc.NamespaceURI = ("")
doc.async = False
doc.Load ("H:\CSXPLUSIIT.xml")
Dim topNode As MSXML2.IXMLDOMElement
Set topNode = doc.documentElement

Dim nsmgr As IXMLDOMNode
nsmgr.NamespaceURI = ("")

doc.SetProperty "SelectionLanguage", "XPath"
For Each RequirementInfo In doc.SelectNodes("//*")
varString = RequirementInfo.SelectSingleNode("RequirementDetails").Text & "<br>" 'Response.Write book.SelectSingleNode("title").Text & "<br>"
'varStringB = VendorApp.SelectSingleNode("Pswd").Text & "<br>"

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums