<< 1 >>
Rating: 
Summary: Great Book but included Excel VBA Projects don't Work!
Review: 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.
Rating: 
Summary: Finally someone who can teach to beginners
Review: I tell you, I must have bought a dozen books related to learning VBA for Excel.
This is the first and only one that I can't put down because this author can start from zero and build up without loosing people.Thanks
Rating: 
Summary: A real stopper!
Review: 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?
Rating:
Summary: Can't Judge this book by its Title!
Review: VBA Programming for the Absolute Beginner, I have to say I'm very disappointed with this book, You certainly can't judge this book by its title!
It seems like it'd be great if you're already an expect macro writer and just need a reminder about what certain functions do. If that's not you, then this book is probably not for you.
I'm a beginner and had trouble at the beginning of the book (page 12). does not work if your using Excel 97, but I have both '97 & 2003 and had problems with both systems. Why would one continue on in a book where you can't get the 1st example to work? I'm sending it back!
Rating:
Summary: A real stopper!
Review: 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.
Rating:
Summary: Previous review is incorrect
Review: 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.
<< 1 >>
| 
