Writing Excel Macros with VBA

Steven Roman

568 pages, parution le 10/09/2002 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

Despite its powerful feature set, you've probably found that there's a lot that you can't do -- or can't do easily -- through Microsoft Excel's user interface. For instance, have you ever wanted to sort the worksheets in a workbook without dragging and dropping each one individually? Have you ever wanted to select a worksheet whose tab was not shown at the bottom of the workbook's window without scrolling through the tabs of all available worksheets? In fact, you can address these and innumerable other shortcomings and extend your control over Excel by using Visual Basic for Applications (VBA) to control Excel programmatically. Writing Excel Macros with VBA is the introduction to Excel VBA that allows you to do just that.
Newly updated for Excel 2002, Writing Excel Macros with VBA provides Excel users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing VBA macros and programs for Excel.
Writing Excel Macros with VBA is written in a terse, no-nonsense manner that is characteristic of Steven Roman's straightforward, practical approach. Instead of a slow-paced tutorial with a lot of hand-holding, Roman offers the essential information about Excel VBA that you must master to write macros effectively. This information is reinforced by interesting and useful examples that solve common problems you're sure to have encountered.
Writing Excel Macros with VBA is the book you need to delve into the basics of Excel VBA programming, enabling you to increase your power and productivity when using Microsoft Excel.

Contents

1 Introduction
2 Preliminaries
3 The Visual Basic Editor, Part I
4 The Visual Basic Editor, Part II
5 Variables, Data Types, and Constants
6 Functions and Subroutines
7 Built-in Functions and Statements
8 Control Statements
9 Object Models
10 Excel Applications
11 Excel Events
12 Custom Menus and Toolbars
13 Built-In Dialog Boxes
14 Custom Dialog Boxes
15 The Excel Object Model
16 The Application Object
17 The Workbook Object
18 The Worksheet Object
19 The Range Object
20 Pivot Tables
21 The Chart Object
22 Smart Tags
App. A The Shape Object
App. B Getting the Installed Printers
App. C Command Bar Controls
App. D Face IDs
App. E Programming Excelfrom Another Application
App. F High-Level and Low-Level Languages
App. G New Objects in Excel XP
Index

L'auteur - Steven Roman

Steven Roman is Professor Emeritus of mathematics at the California State University, Fullerton. Dr. Roman has authored 32 books, including a number of books on mathematics, such as Coding and Information Theory, Advanced Linear Algebra, and Field Theory, published by Springer-Verlag. He has also written a series of 15 small books entitled Modules in Mathematics, designed for thegeneral college-level liberal arts student.

Caractéristiques techniques

	PAPIER
Éditeur(s)	O'Reilly
Auteur(s)	Steven Roman
Parution	10/09/2002
Édition	2^eme édition
Nb. de pages	568
Format	17,8 x 23,5
Couverture	Broché
Poids	885g
Intérieur	Noir et Blanc
EAN13	9780596003593
ISBN13	978-0-596-00359-3