VB6 - ADO - Excel XP, cell formated as text

U

umbelino

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Word macro that can call cells out of Excel for a find and replace 0
trying to email workbook from VB6, getting error 1004 2
Wildcard Filtering on ADO Recordset 1
Find and replace with bold in cells 3
CopyFromRecordset method 1
Copy unformatted value of cell via macro 0
Number displayed as text difficulties 4

Top