Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CellFormat is lost when using CopyFromRecordset
I created an excel template with special format set for certain columns
(e.g. date format, number format, etc). When I copy the data from SQL into this template by using CopyFromRecordset, these formats are lost for those record rows but remained for other rows. Is there any solution that I can keep the pre-defined format set in the template even I use CopyFromRecordset? Thank you very much. Best regards, LUCY ^.^ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: how to convert "27.11.2007 15:13" to number (cellformat fai | Excel Discussion (Misc queries) | |||
Excel 2003 cellformat efter makrokörning | Excel Discussion (Misc queries) | |||
How do I keep a running total of pounds lost and percentage lost | Excel Discussion (Misc queries) | |||
Save Cellformat in a variable | Excel Discussion (Misc queries) | |||
Copyfromrecordset Bug ? | Excel Programming |