Ricardo, How about using: Application.DataToClip(<<cWorkarea>>,999999,3)
Then pasting the data into Excel using Automation. That way it is really quick. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ricardo Aráoz Sent: 16 August 2007 00:39 To: ProFox Email List Subject: Excel question Ok, got 135 ProFox (224 Python, 63 Python Tutor, have to stop slacking) mails to be read, so I hope this is not yet a subject. My reports generate Excel files, if the report is too long (more than 64000 lines) I use different pages in the same file. I have two ways to do it, either I export up to say 15000 lines with a copy to command to a temporary excel file, then open it (as an excel object), copy it's contents to the clipboard (through excel command) and then copy the clipboard to a new page in my multi page excel file. The pro of this method is speed, the con is that if the customer uses the clipboard he interferes with the report. The other way is to insert the data cell by cell, but if the file is too large it gets slow. Does any of you know of some other way to optimize this? 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.
