VFP9SP2 We've got legacy code that uses Excel automation to take data and put it into a template file (XLT). Problem is that the Template was an Excel 2002 template file, and we were trying to add more than 65536 rows. Resulting XLS file would only show maximum rows (65536). So we upgraded their Excel version to 2007, also saved the XLT file as XLTX in 2007.
So I added a checkbox to the UI to allow the user to indicate they want to use the 2007 XLTX file was well as save out to a XLSX file. First attempt is having some issues. I'm digging into it soon, but wanted to ask others if their Excel automation code has met any challenges when going from pre-2007 to 2007? tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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.

