Howdy All,
I create an XML file from MS-Visual Basic and then modify the file in Excel.
In the generation of the XML, I create code like:
<Row>
<Cell>
<Data ss:Type="String">Support</Data>
</Cell>
<Cell ss:StyleID="stENTRYCELLSHADE">
<Data ss:Type="Number" DBKEY="355354">0</Data>
</Cell>
In excel I add a new row using VBA but I cannot see any way of adding the DBKEY="XXX" attribute to the cell in XL.
Anyone any bright ideas?
Thanks
Colin
Blue Skies! Soft Landings!!
I create an XML file from MS-Visual Basic and then modify the file in Excel.
In the generation of the XML, I create code like:
<Row>
<Cell>
<Data ss:Type="String">Support</Data>
</Cell>
<Cell ss:StyleID="stENTRYCELLSHADE">
<Data ss:Type="Number" DBKEY="355354">0</Data>
</Cell>
In excel I add a new row using VBA but I cannot see any way of adding the DBKEY="XXX" attribute to the cell in XL.
Anyone any bright ideas?
Thanks
Colin
Blue Skies! Soft Landings!!