Publisher: Microsoft Press Released: February 2004 Pages: 624
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. |
- Title:
- Microsoft® Office Excel 2003 Programming Inside Out
- By:
- Curtis Frye, Wayne S. Freeze, Felicia K. Buckingham
- Publisher:
- Microsoft Press
- Formats:
-
- Print
- Ebook
- Safari Books Online
- Print:
- February 2004
- Ebook:
- November 2009
- Pages:
- 624
- Print ISBN:
- 978-0-7356-1985-2
- | ISBN 10:
- 0-7356-1985-9
- Ebook ISBN:
- 978-0-7356-9195-7
- | ISBN 10:
- 0-7356-9195-9
|
Curtis 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. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
 |
|
 |
|
|
|
Recommended for You
|
Recently Viewed
|
 |
|
By Sanjay Mishra, Alan Beaulieu
April 2002
By Ethan Watrall, Jeff Siarto
December 2008
Ebook: $39.99
Print & Ebook: $54.99
Print: $49.99
|
Customer Reviews
12/31/2009 4.0No instructions to receive eBook
|
|
|
Merchant response: You can find the example files and downloads that accompany this book by following the Examples link below the image of the book's cover on this page. The link is http://examples.oreilly.com/9780735619852/