stanl
01-06-2013, 08:47 AM
I have an Excel Templates that holds daily rankings from an ADO recordset broken down in color-coded quintiles. My code first issues .clearcontents on each tab then issues SQL to select a recordset to re-populate the data range in each tab (11 in all).
If I use Excel's CopyfromRecordset the data fills the tab but the formatting is lost.
If I use ADO's getstring() copy the results to the clipboard then use pastespecial there is no problem, but more overhead.
It is something I can live with but just wondering why copyfromrecordset cannot keep the formatting.
[EDIT] probably should have done more research before posting; looks like I'm not the only one who has asked. Also seems to be a moot point. Thank you GetString()
If I use Excel's CopyfromRecordset the data fills the tab but the formatting is lost.
If I use ADO's getstring() copy the results to the clipboard then use pastespecial there is no problem, but more overhead.
It is something I can live with but just wondering why copyfromrecordset cannot keep the formatting.
[EDIT] probably should have done more research before posting; looks like I'm not the only one who has asked. Also seems to be a moot point. Thank you GetString()