VBA and Macros for Microsoft Excel

This book is excellent if you want to know how to do VBA and macro's and other stuff. There are files included which you can test the macro's and look at how they did it. Also, you'll need to be able to research online to supplement what this book offers.I work for a school district and everyone claims to be an expert in Excel and Access. I have coworkers I personally know who applied for promotions and got it, based on lying on their apps about skills in Excel and nobody checking. Though I know they are NOT experts. I was honest and put down moderate experience. However, after a few months with this book I've able to make virtually any VBA or macro, or at least be able to research it online and copy it from there. I can automate reports and such and everyone considers me a expert in Excel now. Unfortunately, with the downturn in the economy, nobody is hiring and our school district continues to layoff but at least I know excel!The problem with Excel though is that you can only do these VBA/macro in Excel. The good news is most people prefer reports and spreadsheets to be in Excel versus Access or any other, simply because you can manipulate data in Excel. Access is better if you want reports that are standardized, don't change much and nobody needs to play with the data afterwards.Bad side with Excel is it is time consuming to learn and there is a lot of room for error, especially if you are automating dozens of reports and I've had to automate about 50 of them just the last 2 months. They are going to throw more at me too because I'm the fastest, most accurate, Excel user in the office. I credit my motivation and this book + online research for that.An example of some automated reports I do at the school district which this book has helped me:1) Attendance Reporting - Some spreadsheets/reports show the rate which teachers submit daily "period" attendance and those who are late. Also, breaks down students who attend school over 97%, 87%, etc. While these are more formulas that reference datasheet's back into the report, I still need to do VBA's that convert schools into different names, format, splitting excel sheets into multiple files, etc. These are all automated. You can do it by hand but it will be time consuming and more chance for error. The book shows some tips but the rest you'll have to look up online or do yourself. Nevertheless, the book is a excellent starting point.Remember, this book is a guide and you still need to do some research online to complete it but I highly recommend.

This book is undoubtedly the best book available on this subject. I have read a number of books on VBA and this books is simply miles ahead of the other books.I teach a course in India on Financial Modeling Using Excel to the MBA students in India and I use macros a lot in my models. I was looking for a good book on this subject which I can refer to for this course (as a reference book). What I like the most about this book are the following:Simplicity in writing style: Everything is very clearly and lucidly explained. It is also written as a self-help guide. You can open your laptop, read each page and experiment with VBA. The author really knows how to communicate with the audience and he does that beautifully in each page in this book.Arrangement of Topics: The topics in this book are arranged in the best possible way. Most beginners struggle with the macro security issue and the book deals with these annoying issues in the very first chapter itself.Lots of Short, simple, and extremely powerful examples: This book is full of them. No matter whether you are a beginner, an intermediate user or an advanced user of VBA, you will find something for you in this book.I will strongly recommend this book to anyone who does serious macro programming.

Even if you know VBA you can only get so far without the help of someone who knows the objects and structures and possibilities of Excel. I know Word VBA well, but floundered around with Excel macros until I gave in and bought a book.This one is accurate, straightforward, and comprehensive. It won't teach you the basics of coding or of VBA, but it will enable intermediate-and-up developers to do useful things with Excel macros.Sure, the Internet probably has solutions to every individual problem you have...if you can figure out the right search terms and if you can distinguish outdated or secondrate solutions from the best ones. A good book with a coherent approach still outdoes the Internet's collective scraps of wisdom.Recommended unhesitatingly.

While I am getting some good information out of this book, I have to say it is not for the beginner. Unless you are naturally intuitive, logical, persistant, and have a good understanding of Excel and programming, you will find this book frustrating. The problem is that a lot is left "un-said". Luckily, I have some of the previously mentioned qualities and I was a whiz at the old Lotus macros (soooo much easier) so this isn't completely new to me.I have since bought the John Walkenbach book, "Excel 2010 Power Programming with VBA" and hightly recommend that for someone just starting out or not very intuitive. Walkenbach fills in a lot more of the gaps and really explains the whole VBA experience from the beginning in good, concise detail. After I get through more of the Walkenbach book, I'll return to this book because it does have a lot of useful information, I'm just not prepared for it yet.

I have experience writing programs in procedural code but have never been able to grasp the VBA macro language. If you are in this situation, I would recommend this book. It starts off with an analogy of how you would say "Kick the ball" in VBA code. It continues to show how you would add adjectives and adverbs such as "kick the soccer ball hard". I found this extremely helpful.The book is filled with working examples of VBA code. One of the examples was for the a process that I had tried to write vba code for but couldn't. I would recommend this book to people who have some programming experience but little to no experience with VBA macro programming.

Have been using an Excel database application for a couple of years, and want to make it easier to use, by creating user input forms and automating the processing of data into reports. Have never used macros, and decided it would be good to learn a bit more about them. The content of the book looks to be about right for my level of expertise (am OK at creating databases, and using pivot tables to summarize data).

If this cost 5x the price then you should still buy it.I have used this until the pages wore thin.It's not a nighttime reading book, it's a reference work that you can go back to again and again. It's also fat enough to look impressive on your desk.

I bought this book after reading it in my local Libraries on-line section. I have been trying to automate some excel import and chart manipulation tasks. With the help and look ups in here I not only solved all my issues but feel I took the next step in VBA.It really has launched my enthusiasm - I would strongly recommend it to anyone wishing to take up or improve their VBA in Excel.

This is one of those rare things, a technical "how to" book that actually delivers more than it claims on the cover. It is unintimidating, easy to read, and there's a really useful nugget of information on almost every page. As an example, although ostensibly focused only on Excel Macro programming, this book along the way clarifies some critical details on both Excel Pivot Tables and R1C1 cell referencing that another 850-page "comprehensive" book on Excel completely failed to mention.

Help me get the CBAP very good