PDA

View Full Version : CopyFromRecordset vs. GetString()



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()