Excel 2007 VBA Programmer's Reference

This book is aimed squarely at Excel users who want to harness thepower of the VBA language in their Excel applications. At alltimes, the VBA language is presented in the context of Excel, notjust as a general application programming language. The Primer has been written for those who are new to VBAprogramming and the Excel object model. It introduces the VBAlanguage and the features of the language that are common to allVBA applications. It explains the relationship between collections,objects, properties, methods, and events and shows how to relatethese concepts to Excel through its object model. It also shows howto use the Visual Basic Editor and its multitude of tools,including how to obtain help. The middle section of the book takes the key objects in Exceland shows, through many practical examples, how to go about workingwith those objects. The techniques presented have been developedthrough the exchange of ideas of many talented Excel VBAprogrammers over many years and show the best way to gain access toworkbooks, worksheets, charts, ranges, and so on. The emphasis ison efficiency—that is, how to write code that is readable andeasy to maintain and that runs at maximum speed. In addition, thechapters devoted to accessing external databases detail techniquesfor accessing data in a range of formats. The final four chapters of the book address the followingadvanced issues: linking Excel to the Internet, writing code forinternational compatibility, programming the Visual Basic Editor,and how to use the functions in the Win32 API (Windows 32-bitApplication Programming Interface).