O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »
Answered by Michele Milesi : Mar 20 2012 11:15 PM
You may try to use Apache POI (poi.apache.org) that works both with XLS and XLSX formats.
You can create a new workbook with three sheets, then open each of the original excel files and append the re... full answer >
Answered by rachel.j : Mar 16 2011 01:44 PM
Thanks for writing us about this, and I'm sorry for the delay in responding. It looks like we're not distributing this book (and it's out of print), so that's why it can't be ... full answer >
Pressing a staggering number of keyboard shortcuts can trigger an equally staggering number of Office commands. The only problem arises when you discover that Microsoft has chosen something bizarre (l...
QuickBooks lets you do lots of cool things with customer info, but say you have a mail merge already set up in FileMaker Pro, or you want to transfer all of your customer records to Access to track pr...
Asked by SUPERNOVIA : 15 September 2010 - 12:39 PM
Answered by Alanle [MS} : Sep 17 2010 07:17 AM
There is, the article that describes how to do this is on the Office site at Running a macro when Excel starts
You can then add the code that renames and creates the sheets with the right names ... full answer >