Excel 2000 VBA: Programmers Reference

4.2 avg rating
( 10 ratings by Goodreads )
 
9780764544019: Excel 2000 VBA: Programmers Reference
View all copies of this ISBN edition:
 
 

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.

"synopsis" may belong to another edition of this title.

Review:

Wrox's growing reputation for putting out well-organized, detail-rich books for programmers gets a boost from Excel 2000 VBA Programmer's Reference. This book--a tutorial as well as a reference--holds a wealth of chewy facts that Excel developers will find very valuable.

The tutorial, accounting for half of the book, covers the various mechanisms available for referring to particular files, sheets, cells, and ranges of cells. It also addresses the graphical representation of data--particularly in charts--and explains the most important aspects of controls and the events they generate. Green--unlike many VBA authors--covers internationalization issues in considerable depth. This is the best VBA book on the market for those planning to write programs for a multilingual usage of Excel. There is also a VBA primer that covers critical VBA syntax and the essentials of object-orientation as it applies to the Excel environment.

The two reference sections--one for Excel's VBA objects and one for the VBA Extensibility (VBE) environment--make up the last half of Excel 2000 VBA Programmer's Reference. The references are comprehensive, but they're organized in a strange way--they list properties, methods, and events with their names, return data types, and descriptions in columns. This would be okay, but when an object's list of members extends over several pages it's impossible to be immediately sure of which object the list refers to. The object name ought to appear on each page. --David Wall

From the Publisher:

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 will be a short introduction to VBA itself, and the rest of the book will document aspects of programming Excel through that object model.

"About this title" may belong to another edition of this title.

Other Popular Editions of the Same Title

9781861002549: Excel 2000 VBA Programmers Reference

Featured Edition

ISBN 10:  1861002548 ISBN 13:  9781861002549
Publisher: Wrox Press, 1999
Softcover

Top Search Results from the AbeBooks Marketplace

1.

John Green, Stephen Bullen, Felipe Martins, Brian Johnson
Published by Wrox (1999)
ISBN 10: 0764544012 ISBN 13: 9780764544019
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Wrox, 1999. Paperback. Condition: New. Seller Inventory # DADAX0764544012

More information about this seller | Contact this seller

Buy New
US$ 33.65
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

2.

John Green; Stephen Bullen; Felipe Martins; Brian Johnson
Published by Wrox (1999)
ISBN 10: 0764544012 ISBN 13: 9780764544019
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Wrox, 1999. Condition: New. book. Seller Inventory # M0764544012

More information about this seller | Contact this seller

Buy New
US$ 38.12
Convert currency

Add to Basket

Shipping: US$ 3.27
Within U.S.A.
Destination, rates & speeds

3.

John Green; Stephen Bullen; Felipe Martins; Brian Johnson
Published by John Wiley & Sons
ISBN 10: 0764544012 ISBN 13: 9780764544019
New Quantity Available: 2
Print on Demand
Seller:
Majestic Books
(London, ,, United Kingdom)
Rating
[?]

Book Description John Wiley & Sons. Condition: New. This item is printed on demand. Seller Inventory # 7410761

More information about this seller | Contact this seller

Buy New
US$ 48.61
Convert currency

Add to Basket

Shipping: US$ 7.19
From United Kingdom to U.S.A.
Destination, rates & speeds