BN.com Gift Guide

Excel 2000 VBA: Programmers Reference

Overview

What is this book about?

Excel 2000 is an important part of the Office 2000 program suite, and will be available in the Premium, Professional, Standard and Small Business editions of Office 2000. Excel has traditionally been the Office suite spreadsheet program par excellence. It still remains that way, but with Office 2000 there is a strong emphasis on between-application automation, ease of use, and the smart new bells and whistles that 2000 ...

See more details below
Other sellers (Paperback)
  • All (14) from $1.99   
  • New (6) from $18.68   
  • Used (8) from $1.99   
Sending request ...

Overview

What is this book about?

Excel 2000 is an important part of the Office 2000 program suite, and will be available in the Premium, Professional, Standard and Small Business editions of Office 2000. Excel has traditionally been the Office suite spreadsheet program par excellence. It still remains that way, but with Office 2000 there is a strong emphasis on between-application automation, ease of use, and the smart new bells and whistles that 2000 brings.

Using VBA (Visual Basic for Applications), the user can program his or her own programs in what is essentially a subset of the Visual Basic programming languages. This is tremendously powerful, as it allows you to create great User Interfaces (forms etc), as a front end to actual spreadsheet and database storage and manipulation. This continues to be one of the great strengths of programming Excel VBA.

What does this book cover?

This book presents a full reference to the Excel object model — which is essentially the object-oriented system of organizing the functional capacities that make up the Excel program. There is a short introduction to VBA itself, and the rest of the book documents aspects of programming Excel through that object model.

This book is in three broad sections:

  • The first part introduces Excel and VBA.
  • The second offers interesting, thematic discussions of some of the capacities available to Excel VBA.
  • The third and final part offers a full reference to the object model of Excel.

Who is this book for?

This book is for the Excel developer or user who already has a knowledge of spreadsheets, and the basic objects of an Excel spreadsheet, and now wants a solid and detailed reference to the main object models present in the Excel structure with examples of how to use these models.

Read More Show Less

Product Details

  • ISBN-13: 9780764544019
  • Publisher: Wiley
  • Publication date: 6/12/1999
  • Series: Programmer's Reference Series
  • Edition number: 1
  • Pages: 744
  • Product dimensions: 6.14 (w) x 9.21 (h) x 1.46 (d)

Meet the Author

John Green

John Green lives in Australia and runs his own company, Execuplan Consulting. He has written for various computing publications and was a contributing editor on Australian PC World Magazine. He also has a history of running seminars and creating Excel training ideos.

Read More Show Less

Table of Contents

Chapter 1: Introduction.

Chapter 2: Primer in Excel VBA.

Chapter 3: The Application Object.

Chapter 4: Workbooks and Worksheets.

Chapter 5: Using Ranges.

Chapter 6: Using Names.

Chapter 7: Filtered Lists.

Chapter 8: Generating Charts.

Chapter 9: Event Procedures.

Chapter 10: Adding Controls.

Chapter 11: UserForms.

Chapter 12: Command Bars.

Chapter 13: Class Modules.

Chapter 14: Addins.

Chapter 15: Interacting with other Office Applications.

Chapter 16: International Issues.

Chapter 17: Programming the VBE.

Chapter 18: Programming with the Windows API.

Appendix A: Excel 2000 Object Model.

Appendix B: VBE Object Model.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

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 2 Customer Reviews
  • Anonymous

    Posted October 12, 2005

    Good practical use

    This book is excelent if you plan to mostly use Vba in Excel. It is not easy to find what you are looking for in the appendix though. The book is best suited to thoughs who need to automate tasks quickly and don't won't to now the 1000 different ways you can format a cell.

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

    Posted December 11, 2000

    Much useful material

    Although 2/3 of this book describes the EXCEL object, stuff you could get on-line, the introductory chapters contain some very useful guidance. For example, we are told that no function can be written that changes the spreadsheet, e.g. by copy or paste of a range. Only subroutines can do this. Learning such things by experience is time consuming, and this book helps you around many of these problems.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

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