VBA to Element Based XML

  • Thread starter Thread starter Dan Gesshel
  • Start date Start date
D

Dan Gesshel

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.
 
Dan Gesshel said:
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.
Click to expand...

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

http://www.microsoft.com/downloads/...28-7071-4979-8a67-3cffcb0c2524&displaylang=en

Keith
 
Back
Top