Microsoft Excel VBA Programming for the Absolute Beginner

List Price: $29.99 Amazon.com Price: $23.99

---

Product Details

• Media: Paperback
• Publisher: Premier Press, Inc. (02 April, 2002)
• ISBN: 1931841047
• Average Customer Review: Based on 3 reviews.
• Amazon.com Sales Rank: 270,693
  

---

Customer Reviews

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

Advanced modelling in finance using Excel and VBA Writing Excel Macros with VBA, 2nd Edition Excel 2002 Power Programming with VBA Learn MS Excel 2002 VBA/XML Programming Definitive Guide to Excel VBA Microsoft Excel VBA Programming for the Absolute Beginner VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel Microsoft Excel 2002 Visual Basic for Applications Step by Step

RECOMMENDED MICROSOFT EXCEL TIPS

Retrieving A Value From A Reference Grid, Using Indexes Listed In Another Range Adding Euro format to the number format in Microsoft Excel Automatically Wrapping Text in a Cell Counting Rows that Match Specific Criteria for Each Column Adding a Picture to a Header/Footer Transposing Cells Inserting the path where the Workbook is saved to the title bar or the status bar using VBA in Microsoft Excel Calculating the Average for Numbers Meeting Specified Criteria Reversing The Order Of Values In A List Changing the Indentation in a Cell