Professional Excel Development: Definitive Guide to Developing Applications Using Microsoft Excel and VBA

Description

“A great how-to book for serious Excel users

When picking up this book, I was an advanced Excel user. Having discovered most of its features by trial-and-error, and coming from a fairly solid programming background, I understood well the interaction between the underlying object model and the sheets appearing on the screen to end users. I have also crafted many sophisticated worksheet formulas, and explored just about every suggestion of literature such as "Excel Hacks" and "Advanced Excel Report Development".

Professional Excel Development offers ideas and tools necessary for designing full-fledged, robust Excel-based applications. It does not spend time explaining how various features work, but rather goes into detail on how to put these features to best use.

Here is what I picked up from this book, together with the authors' Excel 2003 VBA reference:
* ways to leverage Excel's built-in features to avoid excessive coding
* advanced design techniques for using Excel as a WYSIWYG interface designer
* techniques for creating custom menu bars and programming their behavior
* various means of interacting with the user and simplifying their sessions by providing guidance as to which steps need to be taken
* restricting the Excel environment to take on the appearance of a product condusive of the goal stated in previous bullet
* using VBA in conjunction with the Excel object model to create powerful object-oriented structures for spreadsheet-based applications
* programming Excel-based solutions in an executable to provide a more standalone application
* using Windows API calls to increase robustness of the application

One key feature of this book is its consistent approach. The authors maintain a consistent structure, using the same application throughout the book for their "practical example" to demonstrate new features made available through the material in each chapter. Also, the "best practices" approach provides a level of consistency that is generally desired of anywhat sophisticated applications. Useable modules are provided on the accompanying CD, ready to be used in readers' own applications.

In the beginning, the authors explain the audiences for which this book may or may not be intended. They separate these into users, power users, VBA developers, Excel developers, and professional developers. The latter three categories of users will benefit the most from this book, each in his/her own way. VBA developers will learn how to use built-in features (I think this is where I started); Excel developers will learn how to incorporate Excel-based solutions into larger applications; Professional developers will be exposed to a great variety of "best practices", optimization techniques, and various other means for developing consistency in Excel applications.

If you do not fall into the latter three categories, you might not pick up much from this book. It is not useless to you, however; you can still find many worksheet/userform design techniques, and get an introduction to the kind of power VBA-based programming can offer. Nonetheless, you may be well-advised to start off with something simpler, such as John Walkenbach's Excel Power Programming (as alluded to by the authors of this book), simply because the present book assumes a good degree of knowledge and leaves much for the reader to figure out from the fully-functional examples provided - thereby covering the ground that it does.

Overall, this book makes for a wonderful reference to the various under-the-hood features of Excel. Even if you've already encountered many of the techniques described, and could technically discover them further on your own, it is useful to have them readily available in a single collection. Very few items are left out; application design, object-oriented programming techniques, database applications, debugging techniques, Office automation, and external interop are all covered here. Professional Excel Development is a solid reference to be consulted for years to come. ”

Disclaimer:
Contents of this page are indexed from the Internet. All actions are under your responsability. Email us to report illegal contents or external links and we'll remove them immediately.

Please check the description for download links if any or do a search to find alternative books.

Can't Download?
Please search mirrors if you can't find download links for "Professional Excel Development: Definitive Guide to Developing Applications Using Microsoft Excel and VBA" in "Description" and someone else may update the links. Check the comments when back to find any updates.

Search Mirrors
Maybe some mirror pages will be helpful, search this book at top of this page or click here to find more info.

1. Ebooks list page : 3443
2. Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R)
3. Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
4. Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R)
5. Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA (repost)
6. Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
7. Professional Excel Development : The Definitive Guide to Developing Applications Using Microsoft(R)
8. Professional Excel Development: The Definitive Guide to Developing Applications Using ...
9. Professional Excel Development: The Definitive Guide to Developing Applications... (Repost)
10. Professional Excel Development: The Definitive Guide to Developing Applications
11. F1 Get The Most Out Of Excel!: The Ultimate Excel Tip Help Guide: Excel 97, Excel 2000, Excel 2002, Excel 2003
12. F1 Get the Most out of Excel! The Ultimate Excel Tip Help Guide: Excel 97, Excel
13. MBA’s Guide to Microsoft Excel 2000 : The Essential Excel Reference for Business Professionals
14. Mba's Guide to Microsoft Excel 2000: The Essential Excel Reference for Business Professionals
15. Microsoft Excel Functions and Formulas: Excel 97–Excel 2003
16. Microsoft Excel Functions and Formulas: Excel 97–Excel 2003