Microsoft Office Excel 2003 Programming Inside Out - Brossura

Frye, Curtis; Freeze, Wayne S.; Buckingham, Felicia

Brossura

ISBN 10: 0735619859 ISBN 13: 9780735619852

Casa editrice: Microsoft Pr, 2004

Riassunto

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

Su questo libro

L'autore

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.

Wayne S. Freeze is the Head of Software Development for Electrical Controls, Inc., where he builds software 3D graphics applications using Visual Basic, SQL Server and DirectX. He has written more than a dozen books over the years and has over seventy-five articles to his credit. Wayne has been using and writing about Access for nearly ten years, and has over 30 years of experience using all types of computers, from small, embedded microprocessor control systems to large-scale IBM mainframes. He also has a master's degree in management information systems as well as degrees in computer science and electrical engineering.

Felicia K. Buckingham, an expert on Excel and VBA programming, is the principal of FKB Consulting, based in Manitoba, Canada.

Contenuti

AcknowledgmentsWe’d Like to Hear from YouAbout the CDConventions and Features Used in this BookPart 1: Preliminaries

• Chapter 1: What’s New in Excel 2003
• Chapter 2: Exploring Excel

Part 2: Visual Basic for Applications

• Chapter 3: Exploring Visual Basic for Applications
• Chapter 4: VBA Programming Starter Kit
• Chapter 5: Creating Sub and Function Procedures

Part 3: The Excel Object Model

• Chapter 6: The Application Object
• Chapter 7: Workbooks and Worksheets
• Chapter 8: Ranges and Cells

Part 4: Advanced VBA

• Chapter 9: Manipulating Data with VBA
• Chapter 10: Formatting Excel Objects
• Chapter 11: Creating Add-Ins and COM Add-Ins
• Chapter 12: Understanding and Using Events
• Chapter 13: Manipulating Files
• Chapter 14: Developing Class Modules

Part 5: Manipulating Excel Objects

• Chapter 15: Charts
• Chapter 16: PivotTables and PivotCharts
• Chapter 17: Command Bars
• Chapter 18: Customizing Dialog Boxes
• Chapter 19: Creating User Forms
• Chapter 20: Creating Advanced User Forms

Part 6: Excel and the Outside World: Collaborating Made Easy

• Chapter 21: Excel and Other Office Applications
• Chapter 22: Excel and the Structured Query Language
• Chapter 23: Introducing ADO
• Chapter 24: Excel Query Program
• Chapter 25: Excel and the Web
• Chapter 26: Excel and the Extensible Markup Language (XML)

Appendix : About the Authors

Dettagli dell?edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2004
• ISBN 10: 0735619859
• ISBN 13: 9780735619852
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 1
• Numero di pagine: 700