Convert Excel to XML
 

Hi all,

I need to convert an Excel data into XML structure. Can someone help
me with a VBA code?

In Excel, the columns a
term|t1|t2|id|defn|abbr|trns|usg|src|syn|see|addre ss|phone

The XML structure must be as follows (where line=Excel's row):

<?xml version="1.0" encoding="UTF-8" ?
- <glossword
- <line
<term t1="T" t2="TE" id="20"term</term
<trsptranscription</trsp
- <defn
<abbrabbreviation</abbr
<trnstranslation</trns
definition
<usgusage</usg
<srcsource</src
<synsynonym</syn
<seesee also</see
<addressaddress</address
<phonephone number</phone
</defn
</line
</glossword

All suggestions how to do it will be more than welcome!

Thanks

Ivaylo