CODEWITHSUNDEEP
xmlexcelvba
user2151763
user2151763

Reputation: 45

Using Excel VBA to create an XML file

I'm trying to create an XML file from VBA found in Excel, I'm a little hazy on the details though, I've never touched XML or VBA before in my life. I need to write out an XML file with in the following format:

<TextField0 xfdf:original="Brand Name">HEADING1</TextField0>

There will be a bunch of lines like this such as TextField1, which is "Product" and so on. The code I have thus far revelent to this section is this:

   'create Heading element
   Set objXMLelement = objDom.createElement("TextField0")
   objXMLRootelement.appendChild objXMLelement

   'create Attribute to the Heading Element and set value
   Set objXMLattr = objDom.createAttribute("xfdf:original")
   objXMLattr.NodeValue = "Brand Name"
   objXMLelement.setAttributeNode objXMLattr

That creates this output:

<TextField0 xfdf:original="Brand Name"/>

This is of coursem missing HEADING1 and I can't for the life of me figure out how to put that bit in there. I can't seem to append anything to an attribute. Any help will be gratefully received.

Upvotes: 4

Views: 15378

Answers (1)

to StackOverflow
to StackOverflow

Reputation: 124804

HEADING1 is the text that belongs to the TextField0 element, not the attribute.

So you can set it using the objXmlElement.text property.

In response to comment:

I'm struggling to find documentation for this stuff

This MSDN page is a good start.

Upvotes: 5

Related Questions