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
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Sprache
Verlagsort
Illustrationen
Maße
Höhe: 229 mm
Breite: 187 mm
ISBN-13
978-0-7356-1985-2 (9780735619852)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
Curtis Frye is the author of numerous books on Excel and other Office products, most recently the Excel 2007 Pocket Guide. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.
Preliminaries VB for applications The Excel object model Advanced VBA Manipulating Excel Objects Excel & the outside world CD contains complete e-book
