VB6 - ADO - Excel XP, cell formated as text
 

First I must to say Sorry, because my English is not the best. I have
some values that I write into an Excel XP sheet from VB6 using ADODB
connection. The problem is that in Excel XP sheet the numbers in the
cells are formatted as text. (All the cells In Excel have a green
error indicator in the upper left corner). To write the values in
Excel sheet I use INSERT INTO … or AddNew and Update methods of the
RecordSet.

I would like to now how can I copy the values (or one column) of the
MSFlexGrid to Clipboard. It is to Past to another application, like
Excel Sheet or OriginPro 7.

Thanks any Help