VBA to Element Based XML
 

Hello.

Can you write a VBA routine that directly creates an element based XML
document? I have sample coding and I can definitely do an attribute based
XML document and then using an XSL stylesheet, make it element based. I was
just wondering if you could make it element based from the start.

My second question is if so, I am having trouble setting the Range value.
Right now, attribute based I have this:

Call objHeaderPropNode.setAttribute("comm",
CStr(Sheets("Input").Range("BV3").Value))

This works, but is there a way to do the same thing and make it element
based? Any help would be appreciated.

Dan

P.S. and yes, I am way way over my head in this. If anyone can recommend
some good VBA books that have some functional code of converting Excel
documents to XML docs, I would be ecstatic.

Thanks.

VBA to Element Based XML
 

"Dan Gesshel" wrote in message
...
Hello.

Can you write a VBA routine that directly creates an element based XML
document? I have sample coding and I can definitely do an attribute based
XML document and then using an XSL stylesheet, make it element based. I
was
just wondering if you could make it element based from the start.


You should be able to use the Microsoft XML engine for VB6
thats downloadable from msdn

http://www.microsoft.com/downloads/d...displaylang=en

Keith