Hi,
On sheet named AREA has the follow data

A B C
ASD 22 3 4
BSD 6 7 8
CSD 9 11 8
EFD 16 19 8
GFD 27 27 8

Need to convert the data to the below format and then saved as xml
file. Any help with code or direction to where i could get this would be
greatly appreciated.
Can the code be created to convert a specific range of cells?


<data
<variable name="AREA"
<row
<column</column
<columnA</column
<columnB</column
<columnC</column
</row
<row
<columnASD</column
<column122</column
<column3</column
<column4</column
</row
<row
<columnBSD</column
<column116</column
<column7</column
<column8</column
</row
<row
<columnCSD</column
<column119</column
<column11</column
<column8</column
</row
<row
<columnEFD</column
<column16</column
<column19</column
<column8</column
</row
<row
<columnGFD</column
<column27</column
<column27</column
<column8</column
</row
</variable
</data


Regards,
Sujith