MVP Rob Bovey, along with his fellow authors have collaborated together on a new book entitled, “Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET”.
The book looks at a number of best practices for planning, architecting and building Excel applications that are robust, secure, easy to maintain and highly usable.
Professional Excel Development is designed for professional developers and Excel experts and the authors share insider's knowledge that they have acquired building Excel applications for many of the world's largest companies—including Microsoft. Professional Excel Development demonstrates how to get the utmost from Excel, addressing everything from application architectures through worksheet and userform design, charting, debugging, error handling and optimizing performance. Along the way, the authors offer best practices for every type of Excel development, from building add-ins through interacting with XML Web services. Coverage includes:
Preview chapters are available below:
Read Chapter 7 - Using Class Modules to Create Objects
Read Chapter 24 - Excel and VB.NET
The book is available to buy here