Using Excel VBA to create an XML file

Question

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.

to StackOverflow · Accepted Answer · 2013-03-09 18:58:46Z

5

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.

edited Mar 9, 2013 at 18:58

answered Mar 9, 2013 at 16:03

to StackOverflow

125k34 gold badges212 silver badges345 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2151763 Over a year ago

Wow. How simple! Thanks a lot, I'm struggling to find documentation for this stuff.

w5m Over a year ago

Many thanks for the link to the "Program with DOM in Visual Basic" tutorial on MSDN - very helpful indeed.

Collectives™ on Stack Overflow

Using Excel VBA to create an XML file

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related