image

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:

  • Building add-ins to provide new Excel functions
  • Designing effective worksheets, userforms and other user interface elements
  • Leveraging Excel's powerful data analysis features
  • Creating sophisticated custom charts
  • Handling errors, debugging applications and optimizing performance
  • Using class modules and interfaces to create custom objects
  • Understanding Windows API calls: when to use them, and how to modify them
  • Adding worksheet functions with
  • C-based XLLs
  • Programming with databases
  • Controlling external applications from Excel
  • Integrating with Visual Basic 6, VB.NET and Visual Studio Tools for Office
  • Using XML to import and export data and communicate with Web services
  • Providing help, securing, packaging and distributing

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

Share this post :