R
Ron
Hello,
I am writing data to Excel 2002 from Access using ADO.
This is fast, but I keep getting the little green
triangles in each cell containing numeric data (it is the
way ADO writes the data to Excel). So I have to manually
convert each cell to number from the green triangle. I
tried using RecordMacro to see what was happening, but
RecordMacro is not recording the conversion. I am
guessing that the manual action is just formatting the
cell to numeric and re-writing the value in the cell. I
want to be able to programatically identify cells with the
little green triangle so that I can do the same thing.
Any suggestions appreciated how to programatically
identify the little green triangle in the cell.
Note: I tried formatting the cells to numeric on the
given workbook and saving the workbook (like a template,
but .xls). This worked, except that the data may be
numeric or chars. If ADO tries to write a char to a
numeric cell, it dies. So I have to leave the cells as
general format.
Thanks,
Ron
I am writing data to Excel 2002 from Access using ADO.
This is fast, but I keep getting the little green
triangles in each cell containing numeric data (it is the
way ADO writes the data to Excel). So I have to manually
convert each cell to number from the green triangle. I
tried using RecordMacro to see what was happening, but
RecordMacro is not recording the conversion. I am
guessing that the manual action is just formatting the
cell to numeric and re-writing the value in the cell. I
want to be able to programatically identify cells with the
little green triangle so that I can do the same thing.
Any suggestions appreciated how to programatically
identify the little green triangle in the cell.
Note: I tried formatting the cells to numeric on the
given workbook and saving the workbook (like a template,
but .xls). This worked, except that the data may be
numeric or chars. If ADO tries to write a char to a
numeric cell, it dies. So I have to leave the cells as
general format.
Thanks,
Ron