Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XML Element mapping | Excel Worksheet Functions | |||
look for missing element | Excel Worksheet Functions | |||
hidden element | Excel Worksheet Functions | |||
hidden element | Excel Worksheet Functions | |||
Mapping an XML element more than once?? | Excel Discussion (Misc queries) |