-
CopyFromRecordset vs. GetString()
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()
Last edited by stanl; 01-06-2013 at 09:59 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules