5 Comments so far
Leave a reply
Partner Ads
Chatting Corner
Search This Site
Subscribe
Categories
Archives
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- April 2009
- March 2009
- February 2009
- June 2008
- May 2008
Blogroll
Live Stats
Book for no VBA beginners and about professional applications.
A lot of explanations to help us in high level development.
Rating: 4 / 5
This book of advanced Excel development was recommended to me by a co-worker whose project I inherited that used the concepts in the book based on the “Petras Template” example. It’s classy and polished VBA programming and sure, you can brag about the concepts to the techies interviewing you during your next job hunt.
But, be careful.
The book introduces us to the concept of add-ins and templates. So, there you are showing off your project to your manager or users. But, what do they click on? The add-in or the template? What are all those true/false cells over there? How can the user save the workbook? What heppens if you forget to hide the columns that use cell logic. Hmmm. These questions and others will be asked of your typically non-technical users who have NO idea what goes on behind the scenes. If they open up the template and screw around with the code or re-name the add-in, you’ll have chaos.
To be fair, there’s tons of advanced concepts to learn here and no doubt you’ll benefit from them. But, remember, as a developer, your first goal is to produce a robust application. However, you may have click a couple of functions to get all tabs in your template to show. If you don’t do that, you can’t see them! Oh, and don’t forget to save your add-in.xla or all your changes won’t take effect.
Not for beginners or dummies, but for VERY careful developers!
Rating: 3 / 5
Stephen and Rob are clearly masters of the art of Excel application development and have an incredible ability to explain the advanced techniques they use in a way that makes them seem easy. “Professional Excel Development” sets a new standard for Excel technical books and looks to become the standard reference book for the industry. Mastering the techniques in this book has already helped me move toward the head of the Excel development pack! I highly recommend it.
Rating: 5 / 5
This book is written by authors who are highly recognized as preeminent among Microsoft MVP’s and Office solution developers. They share profound professional insights, which proves that when you are truly outstanding in your field, you have nothing to fear by making others great also.
If you want only to learn the power of VBA — and VBA is tremendously powerful as a development tool — be sure you have books like Excel 2002 Excel VBA Programmer’s Reference (WROX Programmer-to-Programmer series) and John Walkenback’s Excel 2003 Power Programming with VBA (John Wiley
Rating: 5 / 5
This is a great book for power programmers. But be aware, this book is not for those who want to learn Excel. It’s just for those who know Excel and want to imrove their programming capabilities.
Rating: 5 / 5