Writing Excel Macros With Vba

( 3 )

Overview

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, ...
See more details below
Paperback (Second Edition)
$29.59
BN.com price
(Save 26%)$39.99 List Price
Other sellers (Paperback)
  • All (30) from $3.60   
  • New (13) from $14.77   
  • Used (17) from $3.60   
Writing Excel Macros with VBA

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$17.99
BN.com price
(Save 43%)$31.99 List Price

Overview

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.

Offering a solid introduction to writing VBA macros and programs in Excel, this guide shows readers how to get more power out of Excel at the programming level.

Read More Show Less

Product Details

  • ISBN-13: 9780596003593
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 7/2/2002
  • Edition description: Second Edition
  • Edition number: 2
  • Pages: 574
  • Sales rank: 878,963
  • Product dimensions: 7.00 (w) x 9.19 (h) x 1.06 (d)

Meet the Author

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

Read More Show Less

Table of Contents

Preface

Chapter 1: Introduction

Part I: The VBA Environment

Chapter 2: Preliminaries

Chapter 3: The Visual Basic Editor, Part I

Chapter 4: The Visual Basic Editor, Part II

Part II: The VBA Programming Language

Chapter 5: Variables, Data Types, and Constants

Chapter 6: Functions and Subroutines

Chapter 7: Built-in Functions and Statements

Chapter 8: Control Statements

Part III: Excel Applications and the Excel Object Model

Chapter 9: Object Models

Chapter 10: Excel Applications

Chapter 11: Excel Events

Chapter 12: Custom Menus and Toolbars

Chapter 13: Built-In Dialog Boxes

Chapter 14: Custom Dialog Boxes

Chapter 15: The Excel Object Model

Chapter 16: The Application Object

Chapter 17: The Workbook Object

Chapter 18: The Worksheet Object

Chapter 19: The Range Object

Chapter 20: Pivot Tables

Chapter 21: The Chart Object

Chapter 22: Smart Tags

Part IV: Appendixes

Appendix A: The Shape Object

Appendix B: Getting the Installed Printers

Appendix C: Command Bar Controls

Appendix D: Face IDs

Appendix E: Programming Excelfrom Another Application

Appendix F: High-Level and Low-Level Languages

Appendix G: New Objects in Excel XP

Colophon

Read More Show Less

Customer Reviews

Average Rating 4
( 3 )
Rating Distribution

5 Star

(1)

4 Star

(1)

3 Star

(1)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 3 Customer Reviews
  • Anonymous

    Posted June 8, 2004

    Writing Excel Macros with VBA - Great book!

    I have found this book both a great reference for breaking down existing VBA code within Excel as well as a tool for learning how to write VBA programs from scratch. I highly recommend this book for people interested in writing Excel Macros!

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted November 3, 2009

    No text was provided for this review.

  • Anonymous

    Posted February 15, 2010

    No text was provided for this review.

Sort by: Showing all of 3 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)