in vba, convert excel to xml

[murugavelmsc]

Hi,

I have a excel with some data. But i want to convert the data in xml file.
Plz help me.

in Excel

link Title
xml/20423325 Guggenheim Museum, NYC
xml/192323325 The Stele of Naram-Sin - coming soon!
xml/23325 Studio Technique Video - Carving

In XML

<?xml version="1.0" encoding="utf-8"?>
<data>
<item no="1" header="yes">
<url target="content"><![CDATA[xml/20423325]]></url>
<title><![CDATA[Guggenheim Museum, NYC]]></title>
</item>
<item no="2">
<url target="content"><![CDATA[xml/192323325]]></url>
<title><![CDATA[The Stele of Naram-Sin - [B]coming soon![/B]]]></title>
</item>
<item no="3">
<url target="content"><![CDATA[xml/23325]]></url>
<title><![CDATA[Studio Technique Video - Carving]]></title>
</item>
</data>
</xml>

Thanks
Murugavel

[Dököll]

Good job posting your code murugavelmsc!

Let's see what our friends in the Access forum can do for ya... I know that you can get database values from an Access database and submit as XML, so you're not too far off.

Do you have VBA code included with this project?

Search a bit here while you wait:-)

Dököll