Microsoft Excel VBA Programming for the Absolute Beginner
||List Price: $29.99
Amazon.com Price: $23.99
- Media: Paperback
Publisher: Premier Press, Inc. (02 April, 2002)
- Average Customer Review:
Based on 3 reviews.
Amazon.com Sales Rank: 270,693
A real stopper!
If you are a beginner then lookout, the code at the very beginning of the book (page 12) does not work if your using Excel 97. What better to have failure at the very beginning and have no way to determine what the problem might be. Why would one continue on in a book where you can't get the 1st example to work?
Previous review is incorrect
You do not need Visual studio installed to run the projects in this book. The errors mentioned in the previous review are caused by changes in the path to the VBA string functions when using Windows XP. You can always just enter the code as is written in the book into a new VBA project using Excel and it will run fine. But the simplest solution is this:
1.) Open the project that is giving you trouble.
2.) Select 'Move or Copy Sheet...' from the Edit menu.
3.) Choose to Move the selected sheet to a new workbook to create a copy.
4.) The new workbook should look just like the previous workbook. Only now the library paths will be updated to what's on your computer and the program will work. You will have to save the new workbook or the program will be lost when you close it and you will have to repeat the above steps.
This problem should have been caught in the reviewing process but we missed it. Sorry. Please ignore my rating. I had to put something in that field in order to respond.
Great Book but included Excel VBA Projects don't Work!
I purchased this book because of its approach to teaching Excel VBA in an interesting and fun way. This was borne out when I started working through the book. It was much better than any other book on the same topic I have attempted to use. However it started falling apart in Chapter 2 when the Excel VBA Projects included with the book would not work. This appears to be due to missing VBA references such as "LCase" and "Format". Where I can find these and how I can install them is not mentioned anywhere. My research indicates that these references are probably part of Microsoft Visual Studio so you will need to purchase and install it before you can work through the included VBA projects! This is a great pity as it greatly detracts from what is fundamentally a really good introduction to Excel VBA. I would have given it possibly a 5 star rating if it had not been for these problems.
RECOMMENDED Microsoft Excel - VBA books
RECOMMENDED MICROSOFT EXCEL TIPS