Excel 2000 VBA: Programmers Reference
| Author | : | |
| Rating | : | 4.17 (532 Votes) |
| Asin | : | 0764544012 |
| Format Type | : | paperback |
| Number of Pages | : | 744 Pages |
| Publish Date | : | 2017-09-02 |
| Language | : | English |
DESCRIPTION:
Excel has traditionally been the Office suite spreadsheet program par excellence. 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. 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. 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. 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. There is a short introduction to VBA itself, and the rest of the book documents
Green--unlike many VBA authors--covers internationalization issues in considerable depth. 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. 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. Wrox's growing reputation for putting out well-organized
A Customer said Take a pass on this one and wait for the "Take a pass on this one and wait for the 2nd Edition" according to A Customer. The Editors at Wrox are to blame for this one. The Authors have plenty to say, but the design and layout make it an impossible read. Who came up with such small type and putting the code behind a gray backgound? The index is also poorly layed out, not nearly enough entries. It's a shame because we need a book like this.. nd Edition. The Editors at Wrox are to blame for this one. The Authors have plenty to say, but the design and layout make it an impossible read. Who came up with such small type and putting the code behind a gray backgound? The index is also poorly layed out, not nearly enough entries. It's a shame because we need a book like this.. A Customer said skip this book. I had a really a high expectations towards this book However, after reading a few chapters I realized that this is not a good guide for a self-study. The author does not provide complete examples, so I had to do more research just to discover a correct code. I will have to buy other book to find a better study guide.. "Pass this book and buy something else" I have had high expectations towards this book. After reading a few chapters, I found this book a difficult to follow. I had expected a self-study guide, but I was wrong. It is not a book for self-starters.