Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XL2XML - Attribute problem

Status
Not open for further replies.

skydive

Programmer
May 30, 2001
16
IE
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=&quot;String&quot;>Support</Data>
</Cell>
<Cell ss:StyleID=&quot;stENTRYCELLSHADE&quot;>
<Data ss:Type=&quot;Number&quot; DBKEY=&quot;355354&quot;>0</Data>
</Cell>

In excel I add a new row using VBA but I cannot see any way of adding the DBKEY=&quot;XXX&quot; attribute to the cell in XL.

Anyone any bright ideas?

Thanks
Colin
Blue Skies! Soft Landings!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top