Most helpful critical review
15 of 19 people found the following review helpful
Missing a key component
on February 23, 2010
I think the book is great. I would give it 4 or 5 stars, but I encountered an issue which left me with a bad taste in my mouth. I downloaded the code examples and tried to run the Investment Examples file in chapter 20. When I open the file, I get this message: "Opening the VBA project in this file requires a component that is not currently installed. This file will be opened without the VBA project. For more information, search Microsoft Office Online for VBA converters." So, dutifully, I went to Microsoft Office Online, searched for VBA converters and ran the installation for Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint. The installation told me that this was already installed on my computer and quit. So, after 30 more minutes of searching the Internet for a solution, I am no closer to figuring out what needs to be installed so that the VBA project will convert. I am most interested in the scenario analysis capability of Excel and I work in the investment industry, so this specific example was the one I really wanted to run. I don't understand how a book on Excel 2007 has horribly outdated examples (yes, the file extension is XLS) that cannot be run.