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.
Product Description
If you are new to programming with Microsoft Excel VBA and are looking for a solid introduction, this is the book for you. Developed by computer science professors, books in the "for the absolute beginner" series teach the principles of programming through simple game creation. Microsoft Excel VBA Programming for the Absolute Beginner, Third Edition provides you with the skills that you need for more practical Excel VBA programming applications and shows you how to put these skills to use in real-world scenarios. Best of all, by the time you finish the book, you will be able to apply the basic principles you've learned to the next programming language you tackle.
About the Author
Duane Birnbaum began programming in graduate school, where he wrote custom software for interfacing the various electronic devices require for his experiments and analyzing the data obtained from them. Since completing his Ph.D. in physical chemistry, he has worked in academia and the biotech industry while continually teaching on a part-time basis. He has been serving as a part-time lecturer in computer science at Indiana University/Purdue University Indianapolis for seven years teaching courses in programming, data analysis, and database design.
Michael Vine has taught computer programming, web design and database classes at Indiana University Purdue University (IUPUI) in Indianapolis, IN and MTI College in Sacramento, CA. Michael has 12 years of professional IT experience with Fortune 500 companies in database development, software engineering, web design and IT project management.
Click Here to see more reviews about: Microsoft Excel VBA Programming for the Absolute Beginner (Paperback)
No comments:
Post a Comment