16 used from �0.01

Have one to sell? Sell yours here

Search inside another edition of this book

Excel 2000 VBA Programmer's Reference [Illustrated] (Paperback)

by Green (Author) "Excel made its debut on the Macintosh in 1985 and has never lost its position as the most popular spreadsheet application in the Mac environment..." (more)

4.1 out of 5 stars See all reviews (9 customer reviews)

Available from these sellers.

16 used from �0.01

Other Editions:	RRP:	Our Price:	Other Offers:
Paperback (New edition)	�19.99	�14.99	28 used & new from �3.02

Customers Viewing This Page May Be Interested in These Sponsored Links

(What is this?)

Excel VBA Programming opens new browser window

www.CleverEgg.co.uk/VBAProgramming - Spreadsheet Design & Development Automate with VBA/Macros

Courses in VB Programming opens new browser window

www.seeklearning.co.uk - Take your Programming skills to the next level. Free Demo. Enquire Now!

Excel Programming opens new browser window

www.JonPearsonAnalytics.com - Excel Support For Your Business Free Consultations.

Customers Who Bought This Item Also Bought

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology)

by Rob Bovey

4.9 out of 5 stars (19) �20.29

Excel VBA Programming for Dummies

by John Walkenbach

4.5 out of 5 stars (19) �8.49

Excel 2003 Power Programming with VBA

by John Walkenbach

4.0 out of 5 stars (3) �22.10

VB & VBA in a Nutshell: The Language: The Languages (In a Nutshell (O'Reilly))

by Paul Lomax

3.9 out of 5 stars (15) �14.62

MS Excel 2000 Power Programming with VBA

by John Walkenbach

4.0 out of 5 stars (5) �36.54

› Explore similar items

Product details

Paperback: 700 pages
Publisher: John Wiley & Sons; illustrated edition edition (19 May 2003)
Language English
ISBN-10: 1861002548
ISBN-13: 978-1861002549
Product Dimensions: 22.8 x 15.1 x 4 cm

Average Customer Review: 4.1 out of 5 stars See all reviews (9 customer reviews)

Amazon.co.uk Sales Rank: 438,222 in Books (See Bestsellers in Books)
Popular in this category:
#48 in Books > Computing & Internet > Microsoft Windows > Programming > Excel

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Product Description

Amazon.co.uk Review

Wrox's growing reputation for putting out well-organised, 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 internationalisation 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 organised 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

Book Description

Excel 2000 is an import 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. 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. This book will be 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.

See all Product Description

Inside This Book (Learn More)
Browse and search another edition of this book.

First Sentence
Excel made its debut on the Macintosh in 1985 and has never lost its position as the most popular spreadsheet application in the Mac environment. Read the first page

Explore More
Concordance

Tag this product

(What's this?)

Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.

What Do Customers Ultimately Buy After Viewing This Item?

	63% buy the item featured on this page: Excel 2000 VBA Programmer's Reference 4.1 out of 5 stars (9)
	17% buy Excel VBA Programming for Dummies 4.5 out of 5 stars (19) �8.49
	8% buy Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology) 4.9 out of 5 stars (19) �20.29
	7% buy Excel 2002 VBA Programmer's Reference (Programmer to Programmer) 4.5 out of 5 stars (4) �21.55

Explore similar items

Customer Reviews

9 Reviews

5 star:		(5)
4 star:		(0)
3 star:		(4)
2 star:		(0)
1 star:		(0)

Average Customer Review

4.1 out of 5 stars (9 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

3.0 out of 5 stars A curate's egg, 2 Jan 2001

By A Customer

This book does have some very useful parts - e.g. the chapter on international settings - though even there the problem with failure to recognise a number input as % is repeated mentioned, but no workaround is proposed. There are some useful tips on gotchas. I found it very light in dealing with User Defined Functions - no indication as to how to create and use a function that returns an array result, or how to programme function help for the user trying to understand the arguments and purpose of a function for instance. Also no coverage of using compiled .dll for additional speed in computationally intensive tasks, and how to pass data to and fro to those.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

6 of 6 people found the following review helpful:

5.0 out of 5 stars Quick and dirty 'solve-it' book, 21 Aug 2000

By A Customer

Many VBA books teach VBA the way foreign languages are taught in school - give the student a thorough grounding in the syntax of the language and bore them to tears. This book in very refreshing in that John Green jumps straight in and teaches you how to write VBA code very quickly. Although there is an introduction to VBA, the excel user that has already dabbled a little with VBA will benefit the most from this book. Although much of the book is taken up with the excel object model (which comes with excel) there are still hundreds of pages of very relevant material which gives the reader a very good grounding in how to write VBA to solve real world problems very quickly.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

5 of 5 people found the following review helpful:

5.0 out of 5 stars Very good - highly recommended, 4 Jul 2001

By A Customer

Very well written and easy to follow, it answered a whole collection of my questions within 1/2 a hour of opening it. If you have already mastered menu handling, classes and the object model then this book is not for you but if you have written some VBA and want to start cleaning it up to a more resilient standard then this is perfect.

Wrox or the authors need to come up with an advanced version of this book which covers areas such as Odbc and External data sources, Excel internals with a view to speeding up code and some of the more useful but esoteric functions available within Excel.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all 9 customer reviews...

Most Recent Customer Reviews

5.0 out of 5 stars Fuse This Reference With MSDN Library For Scorching Results...
Love it!
With its vintage coffee stains (circa 2002) and more dog ears than a Kelly Brook Calendar this little number has survived numerous contracts across the UK. Read more

Published on 26 Oct 2007 by E. Maduka

3.0 out of 5 stars Potentially fantastic resource let down by bad index
This book should be the answer to many a programmer's prayers. There is a little of everything in here and you'll certainly learn a bit simply by reading it. Read more

Published on 4 Oct 2002 by Ned Maxton

3.0 out of 5 stars Nice try, but it falls between too many stools
For an experienced VBA programmer, this book probably offers relatively little. The introduction claims it's aimed at all levels, but as a near-beginner I found it WAY too... Read more

Published on 25 Jul 2002 by Farn Oddy

5.0 out of 5 stars Excellent book. Buy it
I have bought a lot of vba Excel books. This is one of the best.

Published on 15 Nov 2000

3.0 out of 5 stars Light on detail
Almost half of the 700 pages are taken up by two huge appendices documenting stuff you can generally get from the help files. Read more

Published on 28 Feb 2000 by Mark Liversedge

5.0 out of 5 stars Excellent Programmer's reference for professionals
As a professional VBA programmer, I found this book to be an excellent reference. Although I use Excel 97, many of the programming concepts are the same as for Excel 2000. Read more

Published on 15 Aug 1999

› See all 9 customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }