Create bookmark
Writing Excel Macros with VBA
Writing Excel Macros with VBA, 2E PDF
Notes
Please login to add notes
- Table of Contents
- + Preface
- + Introduction
- Part I
- + Preliminaries
-
+
The Visual Basic Editor, Part I
-
+
The Visual Basic Editor, Part II
- + Navigating the IDE
- Getting Help
- Creating a Procedure
- Run Time, Design Time, and Break Mode
- + Errors
-
+
Debugging
-
+
Tracing
- Stepping into
- Step Over (Shift-F8 or choose Step Over from the Debug menu)
- Step Out (Ctrl-Shift-F8 or choose Step Out from the Debug menu)
- Run To Cursor (Ctrl-F8 or choose Run To Cursor from the Debug menu)
- Set Next Statement (Ctrl-F9 or choose Set Next Statement from the Debug menu)
- Breaking out of Debug mode
- + Watching Expressions
-
+
Tracing
- + Macros
- Part II
-
+
Variables, Data Types, and Constants
-
+
Functions and Subroutines
-
+
Built-in Functions and Statements
- + Control Statements
- Part III
-
+
Object Models
-
+
Excel Applications
- + Excel Events
- + Custom Menus and Toolbars
- + Built-In Dialog Boxes
- + Custom Dialog Boxes
- + The Excel Object Model
-
+
The Application Object
-
+
The Workbook Object
- + The Workbooks Collection
-
+
The Workbook Object
- Activate Method
- Close Method
- DisplayDrawingObjects Property
- FileFormat Property (Read-Only Long)
- Name, FullName, and Path Properties
- HasPassword Property (Read-Only Boolean)
- PrecisionAsDisplayed Property (R/W Boolean)
- PrintOut Method
- PrintPreview Method
- Protect Method
- ReadOnly Property (Read-Only Boolean)
- RefreshAll Method
- Save Method
- SaveAs Method
- SaveCopyAs Method
- Saved Property (R/W Boolean)
- + Children of the Workbook Object
- Example: Sorting Sheets in a Workbook
-
+
The Worksheet Object
-
+
The Range Object
- The Range Object as a Collection
- + Defining a Range Object
-
+
Additional Members of the Range Object
- Activate Method
- AddComment Method
- Address Property (Read-Only String)
- AutoFill Method
- AutoFilter Method
- AutoFit Method
- AutoFormat Method
- BorderAround Method
- Calculate Method
- Clear Methods
- ColumnDifferences and RowDifferences Methods
- ColumnWidth and RowHeight Properties
- Width, Height, Top, and Left Properties
- Consolidate Method
- Copy and Cut Methods
- CopyFromRecordset Method
- CreateNames Method
- CurrentRegion Property
- Delete Method
- Dependents and DirectDependents Properties
- Precedents and DirectPrecedents Properties
- End Property
- EntireColumn and EntireRow Properties
- Fill Methods
- Find Method
- FindNext and FindPrevious Methods
- Formula and FormulaR1C1 Properties
- FormulaArray Property
- FormulaHidden Property (R/W Boolean)
- HasFormula Property (Read-Only)
- HorizontalAlignment Property
- IndentLevel Property and InsertIndent Method
- Insert Method
- Locked Property
- Merge-Related Methods and Properties
- Next and Previous Properties
- NumberFormat Property
- Parse Method
- PasteSpecial Method
- PrintOut Method
- PrintPreview Method
- Replace Method
- Select Method
- ShrinkToFit Property
- Sort Method
- SpecialCells Method
- TextToColumns Method
- Value Property
- WrapText Property
- + Children of the Range Object
- Example: Getting the Used Range
- + Example: Selecting Special Cells
-
+
Pivot Tables
- Pivot Tables
- The PivotTable Wizard
- The PivotTableWizard Method
- + The PivotTable Object
-
+
Properties and Methods of the PivotTable Object
- Children of the PivotTable Object
-
+
The PivotField Object
- AutoShow-Related Members
- Sorting Pivot Fields
- + The Fundamental Properties
- + Selecting Ranges
- Dragging Pivot Fields
- Name, Value, and SourceName Properties
- Grouping
- + Data Field Calculation
- CurrentPage Property
- DataType Property
- HiddenItems and VisibleItems Properties
- MemoryUsed Property
- ServerBased Property
- ShowAllItems Property
- Subtotals Method
- + The PivotCache Object
- + The PivotItem Object
- + PivotCell and PivotItemList Objects
- Calculated Items and Calculated Fields
- + Example: Printing Pivot Tables
-
+
The Chart Object
- Chart Objects and ChartObject Objects
- + Creating a Chart
- + Chart Types
- Children of the Chart Object
- The Axes Collection
-
+
The Axis Object
- AxisGroup Property
- + Axis Titles and Their Formatting
- CategoryNames Property
- CategoryType Property and BaseUnit Property
- Crosses and CrossesAt Properties
- Display Units
- Gridline-Related Properties and the Gridline Object
- Position- and Dimension-Related Properties
- + Tick Mark–Related Properties
- Units-Related Properties
- ReversePlotOrder Property
- Type Property
- The ChartArea Object
- + The ChartGroup Object
- The ChartTitle Object
- The DataTable Object
- The Floor Object
- + The Legend Object
- The PageSetup Object
- The PlotArea Object
- + The Series Object
- + Properties and Methods of the Chart Object
- Example: Scrolling Through Chart Types
-
+
Example: Printing Embedded Charts
- Example: Setting Data Series Labels
- + Smart Tags
- Part IV
- + The Shape Object
- Getting the Installed Printers
- + Command Bar Controls
- Face IDs
- + Programming Excel from Another Application
- + High-Level and Low-Level Languages
-
+
New Objects in Excel XP
- AllowEditRange Object
- AutoRecover Object
- CalculatedMember Object
- CellFormat Object
- CustomProperty Object
- Diagram, DiagramNode and DiagramNodeChildren Objects
- Error Object
- ErrorCheckingOptions Object
- Properties
- Graphic Object
- IRTDServer and IRTDUpdateEvent Objects
- PivotCell and PivotItemList Objects
- Protection Object
- RTD Object
- SmartTag Related Objects
- Speech Object
- SpellingOptions Object
- Tab Object
- UsedObjects Object
- UserAccessList and UserAccess Objects
- Watch Object
- Index
Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book focuses on:The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros. The VBA programming language, the same programming language used by the other applications in Microsoft Office XP and 2000, as well as by the retail editions of Visual Basic 6.0. The Excel object model, including new objects and new members of existing objects in Excel 2002. Excel exposes nearly all of its functionality through its object model, which is the means by which Excel can be controlled programmatically using VBA. While the Excel object model, with 192 objects, is the second largest among the Office applications, you need to be familiar with only a handful of objects to write effective macros. Writing Excel Macros focuses on these essential objects, but includes a discussion of many more objects as well. Writing Excel Macros with VBA, 2nd Edition 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 handholding, Roman offers the essential information about Excel VBA that you must master to write macros effectively. This tutorial is reinforced by interesting and useful examples that solve common problems you're sure to have encountered. Writing Excel Macros with VBA, 2nd Edition is the book you need to delve into the basics of Excel VBA programming, enabling you to increase your power and productivity.
Test the closed alpha on paperc.com
Book Details
Authors
Categories
Computers > Programming Languages > Visual BASIC
Publishers
Publication year : 2007
License: All rights reserved ©
Times read: 2,485

