Writing Excel Macros with VBA

ISBN-10: 0596003595
ISBN-13: 9780596003593
Edition: 2nd 2002
Authors: Steven Roman
List price: $39.99 Buy it from $3.94
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: 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)  More...

New Starting from $30.04
eBooks Starting from $31.99
Rent
Buy
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $39.99
Edition: 2nd
Copyright year: 2002
Publisher: O'Reilly Media, Incorporated
Publication date: 7/5/2002
Binding: Paperback
Pages: 576
Size: 7.25" wide x 9.50" long x 1.50" tall
Weight: 1.782
Language: English

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 ExcelMacros 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.

Steven Roman, Ph.D., is a professor emeritus of mathematics at the California State University, Fullerton. His previous books with O'Reilly include "Access Database Design and Programming", "Writing Excel Macros with VBA", and "Win32 API Programming with Visual Basic".

Preface
Introduction
Selecting Special Cells
Setting a Chart's Data Point Labels
Topics in Learning Excel Programming
The VBA Environment
Preliminaries
What Is a Programming Language?
Programming Style
The Visual Basic Editor, Part I
The Project Window
The Properties Window
The Code Window
The Immediate Window
Arranging Windows
The Visual Basic Editor, Part II
Navigating the IDE
Getting Help
Creating a Procedure
Run Time, Design Time, and Break Mode
Errors
Debugging
Macros
The VBA Programming Language
Variables, Data Types, and Constants
Comments
Line Continuation
Constants
Variables and Data Types
VBA Operators
Functions and Subroutines
Calling Functions
Calling Subroutines
Parameters and Arguments
Exiting a Procedure
Public and Private Procedures
Project References
Built-in Functions and Statements
The MsgBox Function
The InputBox Function
VBA String Functions
Miscellaneous Functions and Statements
Handling Errors in Code
Control Statements
The If...Then Statement
The For Loop
The For Each Loop
The Do Loop
The Select Case Statement
A Final Note on VBA
Excel Applications and the Excel Object Model
Object Models
Objects, Properties, and Methods
Collection Objects
Object Model Hierarchies
Object Model Syntax
Object Variables
Excel Applications
Providing Access to an Application's Features
Where to Store an Application
An Example Add-In
Excel Events
The EnableEvents Property
Events and the Excel Object Model
Accessing an Event Procedure
Worksheet Events
WorkBook Events
Chart Events
Application Events
QueryTable Refresh Events
Custom Menus and Toolbars
Menus and Toolbars: An Overview
The CommandBars Collection
Creating a New Menu Bar or Toolbar
Command-Bar Controls
Built-in Command-Bar-Control IDs
Example: Creating a Menu
Example: Creating a Toolbar
Example: Adding an Item to an Existing Menu
Augmenting the SRXUtils Application
Built-In Dialog Boxes
The Show Method
Custom Dialog Boxes
What Is a UserForm Object?
Creating a UserForm Object
ActiveX Controls
Adding UserForm Code
Excel's Standard Controls
Example: The ActivateSheet Utility
ActiveX Controls on Worksheets
The Excel Object Model
A Perspective on the Excel Object Model
Excel Enums
The VBA Object Browser
The Application Object
Properties and Methods of the Application Object
Children of the Application Object
The Workbook Object
The Workbooks Collection
The Workbook Object
Children of the Workbook Object
Example: Sorting Sheets in a Workbook
The Worksheet Object
Properties and Methods of the Worksheet Object
Children of the Worksheet Object
Protection in Excel XP
Example: Printing Sheets
The Range Object
The Range Object as a Collection
Defining a Range Object
Additional Members of the Range Object
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
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
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
What Are Smart Tags?
Smart TagRecognizer Object
SmartTag Object
SmartTagAction Object
SmartTagOptions Object
Appendixes
The Shape Object
Getting the Installed Printers
Command Bar Controls
Face IDs
Programming Excelfrom Another Application
High-Level and Low-Level Languages
New Objects in Excel XP
Index

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×