Excel 2003 VBA Programmer's reference

Collectif Wrox - Collection Programmer to Programmer

1232 pages, parution le 01/07/2004

Ajouter à une liste

Indisponible

Résumé

If you're an Excel user seeking more control over your spreadsheets, or if you are developing Excel applications for others, this comprehensive volume provides what you need to maximize VBA flexibility in the Excel environment. Fully revised and updated, it focuses exclusively on VBA for Excel and provides appropriate information for beginners, Excel programmers, and advanced developers alike.

Packed with examples, code, and screenshots where applicable, this clearly organized reference meets you at the level of your experience and takes you to the next level. From a complete Excel VBA primer to internationalization, advanced debugging techniques, and programming the VB editor, this is your one-stop reference for Excel VBA programming.

Sommaire

Primer in Excel VBA
Programming in the VBE
The Application Object
Object Oriented Theory and VBA
Event Procedure
Class Modules
Writing Bulletproof Code
Debugging and Testing
UserForms
Adding Controls
Data Access with ADO
Creating and Using Addins
Automation Addins and COM Addins
Customizing the VBE
Interacting with Other Office Applications
Programming with the Windows API
International Issues
Workbooks and Worksheets
Using Ranges
Using Names
Working with Lists
Pivot Tables
Filtered Lists
Generating Charts
Office Files and Folders
Command Bars
Smart Tags
Excel and the Internet
XML and Excel

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Collectif Wrox
Collection	Programmer to Programmer
Parution	01/07/2004
Nb. de pages	1232
Format	19 x 23,5
Couverture	Broché
Poids	1494g
Intérieur	Noir et Blanc
EAN13	9780764556609