Recommended books about excel vba

• This book is a single reference that�fs indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
• Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won�ft find anywhere else
• John Walkenbach, aka "Mr. Spreadsheet," is one of the world�fs leading authorities on Excel
• Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
• Includes a valuable CD-ROM with templates and worksheets from the book

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Walkenbach hasn't lost his touch. Belongs on the desk of anyone using VBA with Excel 2007 .

I was happy to find a product that was exactly what I needed. It shipped quickly and is in excellent condition.

Excellent reference for VBA in an Excel setting. Expect to get many years service from this book.

I am a novice to VBA and this is the first book I have purchased on the subject. It has alot of useful information. However, it skims so briefly over many topics. If you have a good grasp of VBA and what it can do, I think this is a nice reference. For someone like me, who is just starting, there is probably something better out there.

Got the book a couple of weeks ago and am about 350 pages into it. Although I have only scratched the surface, I've been able to put together a couple of macros that did exactly what I was asked to accomplish. Great Book.

Having Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50�h flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more.

This guide is not for rank Excel amateurs. It�fs for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you�fre an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes:

• An introduction to the VBA language
• A hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing it
• The essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorder
• The essential VBA language elements, including comments, variables and constants, and labels
• Working with Range objects and discovering useful Range objective properties and methods
• Using VBA and worksheet functions, including a list and examples
• Programming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loop
• Automatic procedures and Workbook events, including a table and event-handler procedures
• Error-handling and bug extermination techniques, and using the Excel debugging tools
• Creating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricks
• Customizing the Excel toolbars
• Using VBA code to modify the Excel menu system
• Creating worksheet functions and working with various types of arguments
• Creating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilities

Author John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there�fs no substitute for hands-on learning. The book is complete with:

• A dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changes
• Information to help you make the most of Excel�fs built-in Help system so you can find out other stuff you may need to know

What are you waiting for? Sure, learning to do VBA programming takes a little effort, but it�fs a Very Big Accomplishment.

I purchased this book as an assist to me - to build upon the knowledge that I have already, regarding Macros and VBA. I know some VB6, and am translating that knowledge through this book. I don't think that I am alone in asserting that any type of "Dummies" book provides good insight/information to those who may even have some existing knowledge of the topic. I will probably purchase another more intermediate book for VBA programming, to extend the experience. The purchase came very quickly as Amazon always does !

The book is poorly written and poorly organized. The book covers very similar types of processes using different syntax without explaining why it used different VB code, so one wonders what why it uses one type of code here and another type of code there. Literally, the book has codes which, when I type verbatim, generates errors. Thoroughly frustrating book. Breezing and useless.

This book is exactly what I needed. I know several program languages so I just needed a good introduction to syntax and the basic functions. This was what I needed. Thanks.

I've purchased other JWalk products in the past and this is another in a line of great JWalk Excel,Access, VBA offerings. This is a very good addition for the user who is not comfy with VBA for Excel. Get this if your delving into Excel VBA for the first time.

I have tried to pick up VBA for Excel a few times, but the pieces just didn't seem to fall together for me. I am in IT, but I don't have a development background. I have solid Excel skills, but still got frustrated with VBA and would put it down. Recently, I had a very specific problem to solve for work and thought I would give it another try.

I decided to get a book with the basics and read it completely first, then try to start coding my project. I was in a hurry so I also got the online upgrade to start reading even before my book got here. I found the book an easy read and occasionally tried a few of the examples as I went along. I got through the book easily in a few days and feel as if I had a good knowledge base to begin.

I am happy to say within 2 weeks, I have completed the project I had first planned and then an even more complex project. I have a third planned now. I used other Excel VBA resources along the way, but have to give credit to this book for getting me started and with the basics so I could even understand where to go next. I see the time and money I invested in this book coming back to me many times over due to the hours and hours of work the macros I have been able to write will save both myself and my team members.

I still have a lot to learn, but I am very satisified with this book. I picked this book because of the other good reviews it has on this Amazon site, so I hope you will find my review helpful to you!!

"Today, no accomplished Excel programmer can afford to be without John's book. The value of Excel 2003 Power Programming with VBA is double most other books-simultaneously the premier reference and best learning tool for Excel VBA."
--Loren Abdulezer, Author of Excel Best Practices for Business

Everything you need to know about:
* Creating stellar UserForms and custom dialog box alternatives
* Working with VBA subprocedures and function procedures
* Incorporating event-handling and interactions with other applications
* Building user-friendly toolbars, menus, and help systems
* Manipulating files and Visual Basic components
* Understanding class modules
* Managing compatibility issues


Feel the power of VBA and Excel

No one can uncover Excel's hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user's guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you're fairly new to Excel programming, here's the foundation you need. If you're already a VBA veteran, you can start mining a rich lode of programming ideas right away.

CD-ROM Includes
* Trial version of the author's award-winning Power Utility Pak
* Over one hundred example Excel workbooks from the book


System Requirements: PC running Windows 2000 SP3 or later, or Windows XP(TM) or later. Microsoft Excel 2003. See the "What's on the CD" Appendix for details and complete system requirements.

I used to write macros by cutting and pasting recorded macros. Many lines of cods made my macros unreadable to others. After using this book with its clear examples I understand what I did wrong in the past and how I can write efficient code in the future. This book is very usefull because of its structure, every chapter is a compleet book.

This book is...I can't find the words. It has helped me tremendously. I have gone further with Excel then I ever dreamed I could on my own. I recommend this book for anyone wanting to get more use out of their spreadsheets.

While I had used this for a course in VBA, and noted that it was an extremely concise text, I found it near useless when I was working on my assignments. This book had the information in it, but oftentimes, I simply could not find this information quickly (if at all), and instead Googled much of my information.

On a positive note, this is a well-written book (note: not well-indexed), and therefore useful if you're learning VBA and exploring each chapter one-at-a-time. If you're looking strictly for a reference book for VBA, however, I would strongly advise against getting this particular text.

Also, this text is not written for beginners (a point that the author makes clear), even though some of the material in this book could only be for beginners (for example, the introductory VBA material).

Excellent book for anyone looking to quickly get up and programming VBA in Excel. Don't have to be familiar specifically with Visual Basic but a reasonable knowledge of programming a help. Would have given it 5 stars if it had a thorough reference section on VBA.

Book was helpful in the setup of various 'maintenance' routines. It gave me a fresh look at the use of properties, allowing me to streamline the coding. Unfortunately, company directives have us converting the work to 'active server pages' with a SQL 2005 database server. Since the source data is Oracle, I have been working on DB to DB utilities.

Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats.

I started working for a hedge fund when I brought this book because I don't know how to use VBA, and impressed my colleages with my rapid improvement in VBA programming. It helps a lot and have a lot of good tricks. Will be very useful if you know some level of programming.

I book this WROX book sight unseen, but after having read these reviews and owning many other WROX books. The immediate trigger for buying was having some of my Excel 2003 macros stop working in Excel 2007 due to the change in color scheme. This book is silent on the new color scheme. On the other hand, "Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)" deals with this issue in depth, so I bought this reference also, and would recommend it over the WROX book. Mr Spreadsheet's book has saved my bacon.

The WROX book doesn't handle the translation of Excel 2003 "lists" to Excel 2007 "tables" completely. I would have liked more info on Structured References, which have the potential to make "tables" actually useful.

I have not finished this book yet but John Green's last book about Excel put me in front of others in development. I am sure; this book will do the same because the same the same author has helped in writing this book. I keep it handy when I need it.

For good or bad the authors went through some trouble to put the basics in front of the book which makes it everyone's book but does not help me and make the book 60 pages fatter.

The brief treatment of VBA syntax and the power of VBA make this text for intermediate users and above in my opinion.

Its broad scope, covering command bars, class modules, ribbonx, open XML and much more make it a source to be mined over time. As a reader's knowledge increases, he is likely to find first one and then another Excel feature that can be utilized using techniques described in this text.

Step-by-step instructions for creating VBA macros


Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.

Discover how to
* Grasp essential programming concepts
* Use the Visual Basic(r) Editor
* Navigate the new Excel user interface
* Communicate with your users
* Deal with errors and bugs

For a "Dummies" book, I must be brain dead. Not that easy to follow

The book is very intuitive and easy to understand but you still need a ton of practice to be a pro with macros.

Overall the book it is pretty good

I have not purchased the book - yet. But, I have purchased other of his books and found them to be well written, helpful and a good learning experience. As the reviewer before me mentions - that he seems to be a nice guy - I can vouch for that. Several years ago, I contacted him about geting a version of his Add-ons disk. Even though I did not purchase anything or even indicate I would purchase anything - he offered me a few bucks off the quoted price. This is a man who teaches because he loves it from what I have seen and experienced. It is NOT all about the money for him. If there was a definition for Excel God in the dictionary, his picture would be next to it. Enough said.

When all is said and done, John Walkenbach only has three things going for him:

One, he really knows what he is talking about. While this is a For Dummies book, and doesn't go down really into the Power Programming (that's another of his books) level, they couldn't have gotten a more knowledgeable person to write it. You can take what he says in the book (or on the books companion web site just in case a typo made it through the editing system) as something handed down on stone tablets.

Second, he really knows how to convey the information he has. I find his writing style to be well laid out, informative, almost a pleasure to read (true pleasure I associate with good Science Fiction, not any computer book).

Third, he really seems to be a nice guy. While I've never met him, the home page on his web site (given at the very beginning of the book) has a has a link - Send e-mail to John Walkenbach. On a couple of occassions, I've had a reason to send him an e-mail asking a question. He's answered promptly, curteously and save me a whole bunch of time.

If you want a quick and rapid introduction to macros or VBA programming (in Excel these are the same thing), something that will get you started, this is an excellent choice. As you become a power user, buy his Power Programming with VBA book, and indeed his other Excel books.

Microsoft Excel can be much more than just a spreadsheet. It has become adevelopment platform in it own right. Applications written using Excel are partof many corporations' core suites of business-critical applications. In spite ofthis, Excel is too often thought of as a hobbyist's platform. While there arenumerous titles on Excel and VBA, until now there have been none thatprovide an overall explanation of how to develop professional-quality Excel-basedapplications. All three authors are professional Excel developers who runtheir own companies developing Excel-based apps for clients ranging fromindividuals to the largest multinational corporations. In this book they showhow anyone from power users to professional developers can increase thespeed and usefulness of their Excel-based apps.

I can't recommend this book highly enough. There is a wealth of advice on best practice for both Excel and VBA, which has not only prompted me to change the way I design new projects, but to revise old projects also. There are also a huge number of examples, including an application developed throughout the course of the book, which demonstrate applications for all the techniques discussed. Definitely not for the beginner, but there's loads of stuff here for intermediate to advanced developers. I think I'll be using this as a desktop reference for a long time to come...

This book of advanced Excel development was recommended to me by a co-worker whose project I inherited that used the concepts in the book based on the "Petras Template" example. It's classy and polished VBA programming and sure, you can brag about the concepts to the techies interviewing you during your next job hunt.

But, be careful.

The book introduces us to the concept of add-ins and templates. So, there you are showing off your project to your manager or users. But, what do they click on? The add-in or the template? What are all those true/false cells over there? How can the user save the workbook? What heppens if you forget to hide the columns that use cell logic. Hmmm. These questions and others will be asked of your typically non-technical users who have NO idea what goes on behind the scenes. If they open up the template and screw around with the code or re-name the add-in, you'll have chaos.

To be fair, there's tons of advanced concepts to learn here and no doubt you'll benefit from them. But, remember, as a developer, your first goal is to produce a robust application. However, you may have click a couple of functions to get all tabs in your template to show. If you don't do that, you can't see them! Oh, and don't forget to save your add-in.xla or all your changes won't take effect.

Not for beginners or dummies, but for VERY careful developers!

When you search the web and most of the books around, you can find solution to your problems most of the time, but you are rarely sure it was the best way to do it and how it would fit to the rest of your code. The authors of this book are not afraid to tell what they suppose to be the best for you, along with full featured versions of code illustrating each chapter.

I found it easy to take the code from a sufficiently leveled chapter and adapt it to get just the application that I needed, knowing it would be fast, clean and complete at the same time, although I didn't understand all the details at first. Now, the book serves as a widely findable documentation for the packages that I make. Highly recommendable.

When picking up this book, I was an advanced Excel user. Having discovered most of its features by trial-and-error, and coming from a fairly solid programming background, I understood well the interaction between the underlying object model and the sheets appearing on the screen to end users. I have also crafted many sophisticated worksheet formulas, and explored just about every suggestion of literature such as "Excel Hacks" and "Advanced Excel Report Development".

Professional Excel Development offers ideas and tools necessary for designing full-fledged, robust Excel-based applications. It does not spend time explaining how various features work, but rather goes into detail on how to put these features to best use.

Here is what I picked up from this book, together with the authors' Excel 2003 VBA reference:
* ways to leverage Excel's built-in features to avoid excessive coding
* advanced design techniques for using Excel as a WYSIWYG interface designer
* techniques for creating custom menu bars and programming their behavior
* various means of interacting with the user and simplifying their sessions by providing guidance as to which steps need to be taken
* restricting the Excel environment to take on the appearance of a product condusive of the goal stated in previous bullet
* using VBA in conjunction with the Excel object model to create powerful object-oriented structures for spreadsheet-based applications
* programming Excel-based solutions in an executable to provide a more standalone application
* using Windows API calls to increase robustness of the application

One key feature of this book is its consistent approach. The authors maintain a consistent structure, using the same application throughout the book for their "practical example" to demonstrate new features made available through the material in each chapter. Also, the "best practices" approach provides a level of consistency that is generally desired of anywhat sophisticated applications. Useable modules are provided on the accompanying CD, ready to be used in readers' own applications.

In the beginning, the authors explain the audiences for which this book may or may not be intended. They separate these into users, power users, VBA developers, Excel developers, and professional developers. The latter three categories of users will benefit the most from this book, each in his/her own way. VBA developers will learn how to use built-in features (I think this is where I started); Excel developers will learn how to incorporate Excel-based solutions into larger applications; Professional developers will be exposed to a great variety of "best practices", optimization techniques, and various other means for developing consistency in Excel applications.

If you do not fall into the latter three categories, you might not pick up much from this book. It is not useless to you, however; you can still find many worksheet/userform design techniques, and get an introduction to the kind of power VBA-based programming can offer. Nonetheless, you may be well-advised to start off with something simpler, such as John Walkenbach's Excel Power Programming (as alluded to by the authors of this book), simply because the present book assumes a good degree of knowledge and leaves much for the reader to figure out from the fully-functional examples provided - thereby covering the ground that it does.

Overall, this book makes for a wonderful reference to the various under-the-hood features of Excel. Even if you've already encountered many of the techniques described, and could technically discover them further on your own, it is useful to have them readily available in a single collection. Very few items are left out; application design, object-oriented programming techniques, database applications, debugging techniques, Office automation, and external interop are all covered here. Professional Excel Development is a solid reference to be consulted for years to come.

This is a great book for power programmers. But be aware, this book is not for those who want to learn Excel. It's just for those who know Excel and want to imrove their programming capabilities.

Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book focuses on:

• The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros.

The VBA programming language, the same programming language used by the other applications in Microsoft Office XP and 2000, as well as by the retail editions of Visual Basic 6.0. The Excel object model, including new objects and new members of existing objects in Excel 2002. Excel exposes nearly all of its functionality through its object model, which is the means by which Excel can be controlled programmatically using VBA. While the Excel object model, with 192 objects, is the second largest among the Office applications, you need to be familiar with only a handful of objects to write effective macros. Writing Excel Macros focuses on these essential objects, but includes a discussion of many more objects as well. Writing Excel Macros with VBA, 2nd Edition is written in a terse, no-nonsense manner that is characteristic of Steven Roman's straightforward, practical approach. Instead of a slow-paced tutorial with a lot of handholding, Roman offers the essential information about Excel VBA that you must master to write macros effectively. This tutorial is reinforced by interesting and useful examples that solve common problems you're sure to have encountered. Writing Excel Macros with VBA, 2nd Edition is the book you need to delve into the basics of Excel VBA programming, enabling you to increase your power and productivity.

This book is very helpfull to understand the objectmodel from Microsoft Excel and VBA. After reading this book it is much easier to write efficient code.

It is a very good reference book for excel compared to many other books which do not deal with excel as deeply as this one does. A good book to have.

This book is the equivalent of the eastern-European piano teacher I used to have when I was a kid: proper learning involves strict discipline and sufferance. If you don't read this mind-numbing book from cover to cover, you won't get anything out of it.

I usually love Oreilly books, but this one has simply been useless for me. Time and time again I open it up for help, and I never find any answer.
Actually, last time I looked up a particular topic, it essentially said "You can do it this way, but there are better ways of doing it", and gave no further information. That's what I call useless information.

Not a bad book but it takes some work to get through the dry parts. I think that the book is decent.

I program in VB & needed a reference to the Excel object model. This book is an outstanding resource!

�gIn this day and age of �etoo much information and not enough time,�f the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of.�h

�|Jerry Kohl, president of Brighton Collectibles

�|

Develop your Excel macro programming skills using VBA instantly with proven techniques

�|

Automate Reports

Handle Errors

Master Pivot Tables

Produce Charts

Build User-Defined Functions

Migrate to Excel 2007

Query Web Data

Build Dialog Boxes

Use Data Visualizations

Automate Word

�|

�|

You are an expert in Excel, but the macro recorder doesn�ft work and you can�ft make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.

• Learn VBA syntax as easy-to-understand English
• Automate Excel�fs power tools: Pivot Tables, Charts, Advanced Filters
• Save hours per week by automating redundant tasks
• Create applications built on top of Excel with custom dialog boxes
• Automatically produce hundreds of Excel reports in seconds
• Understand how changes in Excel 2007 impact your VBA macros

Introduction�|�| 1

1 Unleash the Power of Excel with VBA�|�|�|�|�| 7

2 This Sounds Like BASIC, So Why Doesn�ft It Look Familiar�|�|�|�|�|�|? 29

3 Referring to Ranges 61

4 User-Defined Functions�|�|�|�| 75

5 Looping and Flow Control�|�| 101

6 R1C1-Style Formulas�|�|�|�|�|�|�| 121

7 What�fs New in Excel 2007 and What's Changed�| 135

8 Create and Manipulate Names in VBA�|�|�|�|�| 143

9 Event Programming 155

10 UserForms--An Introduction�|�|�|�|�|�| 177

11 Creating Charts�|�|�| 197

12 Data Mining with Advanced Filter�|�|�|�|�|�|�|�|�| 249

13 Using VBA to Create Pivot Tables�|�|�|�|�|�|�|�| 281

14 Excel Power�|�|�|�|�|�|�|�| 337

15 Data Visualizations and Conditional Formatting�| 373

16 Reading from and Writing to the Web�|�|�|�|�|�|�|�|�|�|�|�|�| 393

17 XML in Excel 2007 413

18 Automating Word�| 421

19 Arrays�|�|�|�|�|�| 441

20 Text File Processing�|�|�|�|449

21 Using Access as a Back End to Enhance Multi-User Access to Data�|�| 461

22 Creating Classes, Records, and Collections�|�|�|�|�|�| 477

23 Advanced UserForm Techniques�| 493

24 Windows Application Programming Interface (API)�|�|�|�|�|�| 517

25 Handling Errors�|�|�|�| 529

26 Customizing the Ribbon to Run Macros�|�| 543

27 Creating Add-Ins�| 569

Index�| 577

�|

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.

In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now.

Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately.

But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to:

• Utilize the built in features of Access and Excel to access data
• Use VBA within Access or Excel to access data
• Build connection strings using ADO and DAO
• Automate Excel reports including formatting, functions, and page setup
• Write complex functions and queries with VBA
• Write simple and advanced queries with the Access GUI
• Produce pivot tables and charts with your data

With Integrating Excel and Access, you can crunch and visualize data like never before. It's the ideal guide for anyone who uses Microsoft Office to handle data.