Customer Reviews

VBA and Macros for Microsoft Office Excel 2007

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

 

 

This book was very helpful for some projects that I needed to accomplish with Excel & VBA. Some of the chapters were extremely enlightening in seeing the big picture of using VBA with Excel and other MS Office applications. Other chapters are excellent resources that I will refer to many times in the future. I would recommend this book for both the beginner (in using VBA) as well as the experienced VBA user.

I find the book simply adequate.

I spent a while looking through books on VBA for Excel 2007 and I chose the Jelen/Syrstad title because is was not one of big fat programming guides. I feel there aren't enough examples provided in the book and the examples from their website are mostly a repeat of the book. I find working with Excel to develop a automatic report a daunting task; the built-in help is nearly worthless, the on-line help is a hit or miss, and that's after I've looked through the book.

I guess I'll be looking for a big fat programming guide with more chart development and, hopefully, one that covers Data Connections and SQL.

I have carefully read through the first 12 chapters before I started my project and I find the information easy to understand and straight forward. If, however, one tries to develop code outside of the examples provided, the frustration level increases.

I've really enjoyed this book. I had a very basic understanding of VBA prior to purchasing this book; and while I certainly wouldn't consider myself an advanced user at this point, the book has been wonderful at explaining the syntax of code. Unfortunately I haven't had a chance to sit down and read the book all the way through. If I had, I believe I would be a better programmer for having done it. Mainly, I use the book for reference when I'm coding macros at work. The book is laid out well so when I run into an issue it's easy to flip to the index and find roughly what I'm looking for. The online component of the book is nice as well - adding even further resources to users. Overall, I would recommend the book to anyone looking to learn more about VBA or to those simply wanting a reference guide.

This book is full of fantastic and useful information. Everything that i always wished i could do in Excel VBA is listed there. Because of the way it is written, my learning and understanding increased greatly is such a short time. It goes straight to the point and has superb examples.

I knew that you could do cool things with VBA in Excel, but had never studied Visual Basic. I had some automation that needed to be done in Excel, so I bought this book and within a week I had my automation done, and now I've moved on to other things using VBA in Excel since I've discovered what can be done. This book made me realize that you truly can do just about anything with Excel. I would recommend this book to anyone who has learned a little about formulas in Excel and wants to take the next step in learning how to make their job easier.

I had not been able to understand how to create a macro, now with this excellent reference I have made several macros without troubles and I have saved a lot of time for making reports at work.

VBA and Macros for Microsoft Office Excel 2007 has been very insightful and easy to comprehend. It covers a wide range of topics and walks you into applications. Chapter 21 on Access connections was for 2003 (mdb) and I was expecting 2007 (accdb) but research on the web advanced that issue. I am pleased and recommend it.

This book gets to the core of the problem with VBA it's a new programming language to learn, and not much helps more than trying to program in it - practice makes perfect. This book certainly helped me get started and I succeeded in doing what I wanted to do.