On 2014-01-14 14:44, [email protected] wrote:
VFP9SP2, Excel 2007

I've got cursor data I need to export to Excel, but I need to name the
Sheet accordingly, too.  And sometimes, I'm going to want to take a
few cursors and put into the same spreadsheet (but of course on
different WorkSheet names).

I'm thinking it's a job for automation but I thought I'd check with
the Pros here first before going down that road.  I had thought there
was a SHEET command in one of the Fox functions but I don't see it in
COPY TO nor EXPORT, and besides, there's a distinct possibility of
going over 65,535 rows so hence another nod for automation I guess.

tia,
--Mike


Forget it...I remember now. Craig Boyd's CopyToExcel tool is what I need. http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx



_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.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.

Reply via email to