Rating:  Summary: Borrow this book from the library. Review: I started with a fairly good understanding of Excel and some elementary Visual Basic. My goal was to understand how macros work in Excel and I was definitely able to achieve that with this book. The book is set up as a series of lessons that take you "step by step" through various projects. The directions are very clear and the screen shots are helpful. In terms of general knowledge gain, I would rate the book highly. However, as a reference manual I was frustrated at my inability to "relocate" interesting passages/ideas in the book. Tidbits of information are scattered throughout the lessons and finding something specific again after your initial go-thru can be very difficult. Subsequently, I would recommend borrowing this book from the library or a friend and then buying a proper reference manual afterwards.
Rating:  Summary: not bad but would look else for vba titles Review: If you're in a hurry to throw together some Excel VBA, this book will get you started. They hold your hand at every step, and even give you a time estimate at the beginning of every excercise. Talk about helping you plan your studies!Its strength lies in its step-by-step approach (as the name rightly implies); its weakness lies in the very same quality. As a serious programmer, I didn't gain much insight from it, since it is long on example and short on theory, but it did bring quite a few of Excel's less-known features to my attention that I now use regularly. For a deeper "I'm already a programmer and know what I'm looking for" kind of source, try "Excel 2000 VBA Programmers Reference by John Green, et al" (ISBN: 1861002548) for that, and you'll be well-satisfied with the combination. That much aside, its treatment of pivot tables is truly superb, and the VBA project code is provided on the CD at every step. So as a get-you-started guide, it's well worth both the time and the money.
Rating:  Summary: A very good introduction to using Visual Basic with MS Excel Review: Most books aiming to teach programming techniques are awful. This book is an exception. Its strength is that you can learn a lot, and there's nothing left unexplained that can confuse the reader. The only disadvantage of presenting everything in examples is that the book probably suffers as a reference (though I haven't gotten to that stage yet). Also, it's a little on the rudimentary side by my standards. Overall, though, a very pleasant surprise; a software text that explains everything and does nothing to confuse the reader.
Rating:  Summary: Microsoft Excel with Visual Basic Review: Programming Visual Basic in Microsoft Exce
Rating:  Summary: Confusing Lack of Explanation! Review: The first two chapters of the book are informative and enjoyable, however, once certain programming concepts come into play (objects, properties, methods, etc.) there is an inexplicable lack of definition and explanation! The teaching style is driven by example, with no break (even for a few pages) to explain the dynamics of these key concepts in plain english. Any reader new to VBA or OOL (such as myself) will find him/herself left in the dark once they hit chapter three. I can only assume that a certain level of basic OOL understanding is expected, but we are never warned of this... until now!
Rating:  Summary: An ideal introduction Review: This book can teach anyone to program in visual basic! To get the most from this book you have to work through it methodically, doing all the exercises. If you have SOME experience of Excel macros, then you will be very tempted to skip the early chapters. Dont!! There are lots of very useful tips hidden in the text. The book goes to a fairly advanced level, but does tend to rush through the advanced topics. As a reference book its not very good, as it is near impossible to find what you are looking for. Many times I have half remembered something and not been able to find it again. But as a teaching aid it is second to none. I am regularly asked to write simple macros for other people. These days I just give them this book and tell them to spend a couple of afternoons working through it!
Rating:  Summary: An ideal introduction Review: This book can teach anyone to program in visual basic! To get the most from this book you have to work through it methodically, doing all the exercises. If you have SOME experience of Excel macros, then you will be very tempted to skip the early chapters. Dont!! There are lots of very useful tips hidden in the text. The book goes to a fairly advanced level, but does tend to rush through the advanced topics. As a reference book its not very good, as it is near impossible to find what you are looking for. Many times I have half remembered something and not been able to find it again. But as a teaching aid it is second to none. I am regularly asked to write simple macros for other people. These days I just give them this book and tell them to spend a couple of afternoons working through it!
Rating:  Summary: A very incomplete book Review: This book is a good INTRODUCTION to visual basic programming. If you have never used VB at all, this is a good book to expose you to what VB has to offer. But once you finish reading it, you will definitely feel the need to buy a REFERENCE book for VB.
Rating:  Summary: Borrow this book from the library. Review: This book was exactly what I needed: a good introduction to Visual Basic and how to use it in Excel 97. It assumes no prior VB experience, but it helps to have some programming experience to understand the vocabulary and concepts used. You will never be able to use Excel 97 to its full potential without knowledge of VB, trust me. I am continously amazed at the flexibility and power of Microsoft Office. This book allows Excel users to unlock this power. It should be noted that this book is not made as a reference, but as something to read from front to back.
Rating:  Summary: Good to get you started Review: This book will introduce you to VB, don't but expect it to make a VB guru out of you. There is enough information to help you get confortable with VB and give you some ideas what to do with it. With that said this book will get you by, depending on what your goals are...
|