Excel 2003 Programming Inside Out

Curtis D. Frye, Wayne S. Freeze, Felicia K. Buckingham

596 pages, parution le 04/03/2004

Ajouter à une liste

Indisponible

Résumé

Designed for advanced users, this supremely organized, one-volume reference will help you conquer programming with Excel 2003—from the inside out!

Dig in—and discover how to put the built-in programming power in Excel 2003 to work! This supremely organized reference packs all the information you need to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, and more—without the fluff. Ace the essentials for programming with Microsoft Visual Basic® for Applications (VBA); working with the new XML capabilities in Excel 2003; getting the most out of new programmable smart tags; using the Excel object model; manipulating and customizing Excel objects; and integrating Excel capabilities with other Office programs and the Web. You’ll gain hundreds of timesaving solutions, tips, and workarounds in an easy-to-access format. Plus, you get code samples, utilities for Excel, a complete eBook, and other resources on CD-ROM. With INSIDE OUT, you’ll discover the best and fastest ways to perform everyday programming tasks—and challenge yourself to new levels of mastery!

L'auteur - Curtis D. Frye

Curtis D. Frye is a coauthor of Microsoft Office Excel 2003 Programming Inside Out and 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.

L'auteur - Wayne S. Freeze

Wayne S. Freeze est consultant en informatique, spécialiste de la programmation de Microsoft Office, Microsoft SQL Server et Microsoft DirectX. Il est l'auteur de nombreux ouvrages et articles sur ces sujets.

L'auteur - Felicia K. Buckingham

Felicia K. Buckingham est experte en programmation Excel et fondatrice de FKB Consulting.

Sommaire

Preliminaries
- What's New in Excel 2003
- Exploring Excel
- Visual Basic for Applications
- Exploring Visual Basic for Applications
- VBA Programming Starter Kit
- Creating Sub and Function Procedures
The Excel Object Model
- The Application Object
- Workbooks and Worksheets
- Ranges and Cells
Advanced VBA
- Manipulating Data with VBA
- Formatting Excel Objects
- Creating Add-lns and COM Add-lns
- Understanding and Using Events
- Manipulating Files
- Developing Class Modules
Manipulating Excel Objects
- Charts
- Pivot Tables and PivotCharts
- Command Bars
- Customizing Dialog Boxes
- Creating User Forms
- Creating Advanced User Forms
Excel and the Outside World: Collaborating Made Easy
- Excel and Other Office Applications
- Excel and the Structured Query Language
- Introducing ADO
- Excel Query Program
- Excel and the Web
- Excel and the Extensible Markup Language (XML)

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Microsoft Press
Auteur(s)	Curtis D. Frye, Wayne S. Freeze, Felicia K. Buckingham
Parution	04/03/2004
Nb. de pages	596
Format	19 x 23,5
Couverture	Broché
Poids	1240g
Intérieur	Noir et Blanc
EAN13	9780735619852
ISBN13	978-0-7356-1985-2