Excel 2007 VBA Programmer's Reference

This book is a comprehensive guide for Excel users who want to harness the power of VBA language in their applications.

It covers the basics of VBA programming, including the relationship between collections, objects, properties, methods, and events, and shows how to relate these concepts to Excel through its object model.

The book also provides practical examples of working with key objects in Excel, such as workbooks, worksheets, charts, and ranges, with an emphasis on efficiency and readability.

Additionally, it addresses advanced issues like linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and using the functions in the Win32 API.

With this book, you'll be able to take your Excel applications to the next level and become a master of VBA programming.