Rating: 
Summary: Re: Huh?
Review: I thought that might be the problem too. But I have Excel 2000 ver. 9.0.2720. So do the other people my office. I think the author rushed and didn't verify the examples really work. BTW: apologies for the double bad review. I didn't think the first review was accepted by the system.
Rating:
Summary: Waste of Money
Review: Guy went thru online help and cut and pasted examples. Can't remember one useful piece of information I got from this book. Keep searching for EXCEL VBA books and leave this one alone.
Rating: 
Summary: Huh?
Review: I suspect that James E Tatem Jr is using an older version of Excel. The book covers Excel 97 and Excel 2000, and will be fairly useless for previous versions.
Rating:
Summary: Keep looking for another book
Review: I got this book from a co-worker, who got it from another co-worker, who got it from a third coworker. None of like this book. No one wants the book back. Yes, we're all skilled users. None of us would be considered novice Office users. I intend to get rid of it. I think it's company property or I'd offer to give it away. The example I tried to follow, using a List Box, was incorrect. The references did follow the actual List Box properties. There were significant discrepancies. In short, the example could not work. So, keep looking. There must be something better out there.If I find it I'll let you know.
Rating:
Summary: Inaccurate and unclear
Review: This book was given to me by a co-worker who could not use it. It had been given to him by another co-worker who could not use it. I intend to give it away as well. We're all self-proclaimed Excel power users who wanted to learn more about the VBA features of Excel. The examples are not only unclear, they're inaccurate. I tried to follow one, and could not do it. The examples did not match the Excel windows, property fields were not identified correctly. The mistakes are significant. If I find something better I'll let you know. Keep looking for another book.
Rating:
Summary: Excellent VBA Starter and Reference Guide
Review: I have found this book to be an exceptional book on leveraging VBA to enhance my abilities in Excel. I have used the procedures and instruction constantly and was well on my way the first day I cracked open the book. If you are good on Excel and have a programming background. This book is a good way to get introduced to VBA
Rating:
Summary: Filled with valuable examples
Review: This is a outstanding reference for VBA in Excel and an outstanding book on VBA. Anyone wanting to get to the power of Excel should have a copy.
Rating:
Summary: Indispensable Reference Tool
Review: I spend a lot of time writing Excel macros for my current employer and I can tell you that Excel 2000 Power Programming with VBA has been an invaluable tool. I was familiar with VBA (novice level) before purchasing the book and I feel I've been learning new code at an exponential rate thanks to John Walkenbach's exceptionally clear examples. You really can do some powerful stuff with VBA and Walkenbach is a gifted (and entertaining) teacher. If you have no previous experience, you will be amazed at how easy it is to create professional looking message boxes, input boxes, and even custom multi-page dialog boxes. Walkenbach demonstrates how to add and remove buttons from toolbars and menus, work with cell and range data, use "ActiveX" controls (such as option buttons, check boxes, and combo boxes), run procedures when certain events occur (such as opening a workbook or clicking on the right mouse button), and even how to use API calls to perform functions that are normally outside the scope of VBA (such as identifying the path to the Windows folder or identifying the printer port). All of the code examples (and there are plenty of them) are clearly explained. Walkenbach doesn't just list page after page of code an expect you to figure out what each line accomplishes. Instead, he defines all of the objects and properties he uses and explains the methods he uses to manipulate them. You won't be overwhelmed by the complexity of the code but you will be thrilled about how powerful your macros are. I'll give you an example from my own experience to demonstrate the usefulness of Excel 2000 Power Programming with VBA. I had created several worksheets templates at my job to be used by other employees. I locked several cells that contained formulas because I didn't want the employees to be able to change them. It quickly came to my attention, though, that people could inadvertently destroy the formulas by using Excel's "cut" function on unlocked cells that the formulas referenced. I needed to disable Excel's "cut" function whenever the workbook in question was active. Using the book I found out how to remove the "cut" button from both the "Edit" menu and the standard toolbar, disable the shortcut menu that pops up whenever you right click on a worksheet object (which also contains the "cut" button), and disable Excel's cell drag and drop feature since it produces the same results as the "cut" function. I just inserted the relevant code in the "ThisWorkbook" module as Walkenbach explains, and now nobody can accidentally screw up the protected formulas. I think it's important to note, though, that while this book is OK for novice programmers, it assumes the reader is already very familiar with Excel's tools and functions. Don't buy it if you aren't already an advanced Excel end-user. Some previous experience with VBA would also help, but since Walkenbach spends a good portion of text discussing foundational concepts and providing entry-level code snippets, this book can be just as useful to neophytes as it is to intermediate and advanced developers.
Rating:
Summary: Best book on VBA i ever have read
Review: I am a proffesional developer and i have read books on VBA for many years.I must say that this book is the best one. John Walkenbach has covered many different aspects of VBA-programming in a funny and pedagogic way.
Rating:
Summary: Excellent Book for VBA programmers and Begineers too
Review: I have written some Excel macros that work with CSV files. After buying this book I have been able to reduce my code to a great extent. It has added to my knowledge of built in Excel-VBA functions and I am very happy with the purchase. This book can be very well considered an Excel VBA bible.
Here are some of the good points about this book:
1. Code snippets for most frequent tasks. The author uses Excel's built in definitions and makes it look very easy.
2. The examples at the end of each chapter(and on the CD rom). This library is HUGE!. I love it. It includes more than 100 macros. Some macros include batch processing of files, undoing a macro, putting a progress indicator for a macro... and lot others. :)
3. The author, John W provides great support. He replied to me within 24 hours when I emailed a problem with a macro. That was very cool.
All in all, good worth for the money. Good luck
| 
