I had to try it again, it's been awhile. _VFP.DataToClip(,,3) oExcel.Cells(5,5).Select() oExcel.Selection.PasteSpecial()
I copied several 000's of records in a fraction of a second. You do get your field names in the first row, but it's a simple matter to remove that. Fred 2009/9/18 Ricardo Aráoz <[email protected]> > I'm currently writing reports to excel worksheets (VFP6 - excel2000). I > used to do this through automation but sometimes the output is too big > and cell at a time automation was too slow. After trying different > approaches I am making a 'record set' from my output cursors and then > issue > > "oWkbk.ActiveSheet.Rows(1).CurrentRegion.end(4).offset(1).CopyFromRecordSet(loRecordSet)" > to copy it to the current excel page. > This is faster than copying a cell at a time but slower than a simple > "copy to...type XL5" and then just automate the column headers and > column format. Problem with the "copy to" option is that I need to be > able to output to different work sheets (if the cursor is greater than > 64000 lines, or if the output are a couple of different cursors). > Can anyone think of a way of doing a "copy to" and then telling excel to > put this into a certain work sheet? Any other ideas? > > TIA > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
