Microsoft® Office Excel 2003 Programming Inside Out

I was looking for a book that would give me a very fast start on writing VBA for Excel to do some engineering data manipulation and analysis, I had no previous experience with either VBA or VBA for applications (I knew other object oriented languages though). I started out by looking at one of Walkenbach's books for a week before giving up on it with no result. Initially, I took this book off my list due to bad reviews, but then looking at a bunch of books in a bookstore it was the only one that answered a simple question: "How do I create a new worksheet with the code?", none of the other 5 books I had in my hands could provide me an answer to that simple question. I bought the book and haven't regretted it. I needed that initial boost to start working with VBA for Excel as I haven't worked with it before, once I know the basics I can navigate further by myself and perhaps then other books will start making more sense to me. I assume that the reason for negative reviews is the fact that the book is more basics oriented, but I couldn't find any other book that would give me that. And sorry, while help is good, it's still doesn't explain concepts well, it's simply a wonderful reference. So if you don't want to take a course in VBA and haven't worked with VBA for applications before - this might be a great book for you, I know it was for me. You're a sophisticated user of Excel—a real pro with spreadsheets—so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fast-answer format. Discover the best and fastest ways to build custom business solutions with Excel—and challenge yourself to new levels of mastery! From automating simple tasks to building custom solutions, write better code with VBA Learn best practices for writing and debugging your own macros Use VBA code to manage dates and times, reformat worksheets, and locate external files Extend your Excel solutions by developing your own add-ins Get powerful perspectives on data by programmatically manipulating PivotTable and PivotChart dynamic views Create custom command bars, dialog boxes, and user forms Employ ActiveX Data Objects (ADO) to access external databases Exploit the new XML capabilities in Excel 2003 CD features: Complete eBook in PDF format Insider Extras—including all the authors'sample files and code Catalog of Excel resources with links to third-party tools and demos Microsoft resources and demos, including Insider's Guide to Microsoft Office OneNote 2003 eBook FREE! Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entries A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com. Curtis Frye, Wayne Freeze, Felicia Buckingham. Cd-rom Includes Complete Ebook In Pdf Format, Catalog Of Excel Resources With Links To Third-party Tools And Demos, Microsoft Resources And Demos, And Free Microsoft Comptuer Dictionary, 5th Ed. Includes Index. System Requirements: Pentium 266-mhz Or Higher Processor; Microsoft Windows Xp Or Later Or Windows 2000 Professional With Service Pack 3 Or Later. Take your Microsoft Office experience to the next level by programming custom business solutions with Excel 2003. This supremely organized reference and tutorial packs hundreds of timesaving answers, tips, and workarounds for advanced Excel users. Microsoft Excel has been around since 1985, so it's no surprise that the basic spreadsheet elements of the program have remained fairly constant for quite some time.