Microsoft Excel VBA Professional Projects

Rating:
Summary: For Advanced Users Only
Review: This book's subtitle "Professional Projects" led me to believe that the projects would be useful examples easily adapted to typical business situations. I was wrong. The books starts out with a breezy 150-page overview of VBA but then goes into the development of four projects that incorporate the most complex aspects of VBA programming. The first project is enough for all but the most experienced VBA programmer to shelve the book and forget about it. The first project, an excel-html converter, is preceded by three chapters that describe the necessary components for the converter: Custom Menus, Charts and Custom Objects. It is highly unlikely that the average business user is going to expend the time and energy to learn how to create their own custom objects particularly for a project of such little usefulness. The second project is a Data Analysis project incorporating a data exchange with Access and pivot tables. The third project involves creating a stock ticker with internet access and the final project involves automating data analysis and fitting a curve to the data. I did like the format of the book whereby each project is preceded by a couple chapters explaining the components (excel objects) that make up the project but those chapters are not in-depth enough for the casual VBA to fully grasp what is going on. The projects themselves are suited for an experienced users or those seeking to become serious VBA programmers. For the business user I recommend instead Albright's VBA for Modelers.

Rating:
Summary: For Advanced Users Only
Review: This book's subtitle "Professional Projects" led me to believe that the projects would be useful examples easily adapted to typical business situations. I was wrong. The books starts out with a breezy 150-page overview of VBA but then goes into the development of four projects that incorporate the most complex aspects of VBA programming. The first project is enough for all but the most experienced VBA programmer to shelve the book and forget about it. The first project, an excel-html converter, is preceded by three chapters that describe the necessary components for the converter: Custom Menus, Charts and Custom Objects. It is highly unlikely that the average business user is going to expend the time and energy to learn how to create their own custom objects particularly for a project of such little usefulness. The second project is a Data Analysis project incorporating a data exchange with Access and pivot tables. The third project involves creating a stock ticker with internet access and the final project involves automating data analysis and fitting a curve to the data. I did like the format of the book whereby each project is preceded by a couple chapters explaining the components (excel objects) that make up the project but those chapters are not in-depth enough for the casual VBA to fully grasp what is going on. The projects themselves are suited for an experienced users or those seeking to become serious VBA programmers. For the business user I recommend instead Albright's VBA for Modelers.