Customer Reviews

Excel Programming: Your Visual Blueprint for Creating Interactive Spreadsheets (With CD-ROM)

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

 

 

To put my review into context: I used to be able to write useful Excel macros in the old Excel 4.0 / Excel 95 macro language. I'm not a programmer, and certainly not an advanced macro user, but I could use the old language to do what I needed to do: mostly just speeding or automating routine Excel tasks.

When VBA replaced the 4.0 macro language, I tried for years to understand it, but VBA just never clicked with me. I never needed it so badly that I would put myself on a course, or plough through a dense text book, though I did routinely look (without success) for something that would help me to get my head round the format.

Finally I came across this book in a bookstore, and it instantly began to make sense. I started by just looking through the text in the store, and going back to my PC to use what I had learned. By my third time back to the store for more tips, I realized that this was actually what I needed and bought the book. I am now comfortable with the format, and still learning through writing simple VBA's as and when I need them. I attribute this entirely to this book.

I recommend it to anyone who, as I did, just finds the whole VBA format daunting. The book's format is very visual - much more so than other VBA books (including "VBA For Dummies", which I own, but which didn't help me at all). This (visual format) means that each topic is very quick to learn, and you're not left wondering how you can use a particular function. Each function is described in very "bite-sized" sections, mostly two facing pages, and occasionally four. Each two page topic is at most half text, with the rest screen-shots and comments on the screen-shots. It just really works well.

By all means get another VBA macro manual as a reference, but if you really want to get started in the format without also getting put off by it, this book is the only one that I have found that fits the bill.

For some time, I have wanted to program in Visual Basic for Applications as a means to automate Excel 2000/2002. I have looked at many titles in the bookstore by various authors (experts in the field, unquestionably), but none seem targeted to the novice or intermediate user who simply wants to understand the VBA environment and how to benefit from its powerful capabilities. If other books were trying to target such an audience, then they suffered from poor readability and simply too much material. This book instills confidence in novice users as the reader is given very succinct explanations on variables, procedures, subroutines/functions, and, of course, the Excel Object Model. I have not been able to put the book down, practically speaking.

Extremely well organized, with generally very good and detailed graphics. It makes its point in roughly 325 pp. and features an excellent appendix dealing with constants, etc. I believe this book will forever relegate the more pricey books I have on the subject to a shelf in my technical library. The others are authoritative books, to be sure, but I never gained confidence with the format. Reading other sources proved exhausting when compared to this book. As an Excel user who wrote some macros in the Excel 95 version of the software, this book is a welcome addition. The book contains probably a few typos, and perhaps an illustration or two (screen shots of the Excel or VB Editor interface) is unclear or improperly rendered (such as in the section "Remove a Module"). Minor, minor details that won't matter in the overall scheme of things - this book rates very high in my opinion. Another plus: the CD ROM has the sample code used in many sections in the book as well as an "e-version" of the book itself.

This nifty guide book is pretty different from most computer programming books out there, it targets a very specific group of people, namely those who are proficient in Microsoft Office but with little knowledge in VBA. Even more specifically, it is a dictionary for people who are trying to write macros in the fastest way possible, no time is wasted on explaining the fundamentals of VBA or programming in general.

Readers who skim through the book in a bookstore might be decieved into thinking that this book is for newbies due to the abundance of pictures/screenshots scattered throughout the pages. It is not. The book is essentially structured in a manual format with each spread of 2 pages covering a certain function. Neither is there any fluff for the beginner nor are there complex code snippets for the advanced user.

This text should be used primarily as a quick VBA reference book for people who are proficient in MS Excel but looking for quick and dirty ways to churn simple macros.

I am a programmer and frequently work with many people that are not. This book is great to grab the CD and share a concept or share an idea. The entire book is on CD-ROM in the back of the book that by the way is in PDF format so that you can enlarge it to almost 400 percent (so much for readability issues).

I thought initially that this book was highly duplicitous of its brother book Excel Data Analysis by the same company. There are some areas that overlap but I will pass on criticism.

Every example has the initial worksheet and the solved or worked through example on the included cd-rom.

If there is any room they could have done better with, is using a larger font and pulling out what example they are using from the top of the excel worksheet onto the page. Therefore, when you open to the topic of "Record a Macro" they would have had "Budget Worksheet" example in the same font size next to it. As it currently is, there is a bit of eyestrain but it is not that bad.

This is a good book for what I used it for, which is a few quick and dirty VBA apps in Excel. Beginners can easily pick it up and go with the information in this book. If you want to get heavier into development, you may want something with a few more code examples, and better explanations as to what is going on. This book is very good however, and presenting information for creating specific projects.

Excellent book for people who need to learn the two object models quickly while providing a strait to the point explanation, and an example of how to use it in you project.

This has to be one of the best self-study books around.

This book is very beginner oriented. All of the explanations target one basic function in Excel, but never are they all tied together in a more complex example. There were also several grammatical errors, which add to the amatuerish nature of the text.
If you're looking to do very simple things with your Spreadsheets, then this will do the job, but otherwise, look elsewhere.

This book is excellent for people who already know their way around Excel and need to get started with macro programming fast. Those wanting to continue to advanced macro programming will undoubtedly want to move on to another book, but I think this is a fantastic way to get going. I found the formatting (2-page sections) very convenient.

The book is ok, but If youre new to the Excel Macro and Programming world, dont buy this book!
I use above average formulas in excel such as left, vlookup, hlookup, right, mid, match, concactenante, and the normal formulas. But i really thought this book could've given me a better insight to excel VBA programming.
I have friends that program and I always see the word "DIM" in their coding, so I expected this book to explain these details, but they actually skipped it. They wrote it directly to an example with no explanation. How can you right code and not know this???
Defenitely for a semi pro programmer.

i have a number of VbA books and each one seems to offer its own unique solution to a problem that I cant find in the others. This book is no exception. A good book to own for the library. I had some experience with VBA before I bought the book and I'm not sure how it would read if had no experience. Probably just fine.

Overall a great reference.