Microsoft® Office Excel 2003 Programming Inside Out

About The BookConquer Excel programming—from the inside out! 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 2003CD 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

About Curtis Frye, Wayne S. Freeze and Felicia K. BuckinghamCurtis Frye is the author of Microsoft Office Excel 2003 Step by Step, Microsoft Excel Version 2002 Plain & Simple, Faster Smarter Home Networking, several books on Microsoft Access, and numerous online training courses. Wayne S. Freeze, a computer consultant and author with more than a dozen books and 50+ articles to his credit, specializes in programming for Microsoft Office, Microsoft SQL Server™, and Microsoft DirectX®. Felicia K. Buckingham, an expert on Excel and VBA programming, is the principal of FKB Consulting, based in Manitoba, Canada.

Other Books By Curtis Frye Microsoft® Access Version 2002 Plain & Simple Microsoft® Office XP Step by Step Microsoft® Excel Version 2002 Step by Step The Microsoft® Office Excel® 2007 Toolkit: Microsoft Office Excel 2007 Step by Step and Create Dynamic Charts in Microsoft Office Excel 2007 and Beyo 2007 Microsoft® Office System Step by Step Microsoft® Office System Step by Step -- 2003 Edition Microsoft® Office Accounting Professional 2007 Step by Step Microsoft® Office Small Business Accounting 2006 Step by Step Microsoft® Excel® 2010 Step by Step Microsoft® Excel® 2013 Step By Step Microsoft® Office Excel® 2007 Step by Step Microsoft® Office Excel® 2007 Plain & Simple Microsoft® Office System Step by Step -- 2003 eLearning Edition 2007 Microsoft® Office System Step by Step, Second Edition Microsoft® Office Home and Student 2010 Step by Step Microsoft® Office Excel® 2003 Step by Step Microsoft® Office Access™ 2007 Plain & Simple Microsoft® Excel Version 2002 Plain & Simple Microsoft® Office Professional 2010 Step by Step