Book cover for Excel 2007 VBA Programmer's Reference by John Green, Stephen Bullen, Rob Bovey and Michael Alexander
2011 Released
1176 Pages
14-15 Hours
Audiobook Unavailable
Paperback Unavailable
Hardback Unavailable
Wrox ISBN 9781118169360
This book is aimed squarely at Excel users who want to harness the power of the VBA language in their Excel applications. At all times, the VBA language is presented in the context of Excel, not just as a general application programming language.

The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to 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 Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency—that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats.

The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).

John Green

John Green is the award-winning, bestselling author of numerous books, including ones that have won such awards as an Edgar Award, a Printz Medal, and a Printz Honor. He has twice been a finalist for the Los Angeles Times Book Prize and was selected by Time magazine as one of the 100 Most Influential People in the World. With his brother, Hank, he has co-created many online video projects, including Vlogbrothers and the educa-tional channel Crash Course. He serves on the board of trustees for the global health non-profit Partners In Health and spoke at the United Nations High-Level Meeting on the Fight to End Tuberculosis. You can visit him online at johngreenbooks.com or join the TB Fighters working to end tubercu-losis at tbfighters.org

More by John Green

Michael Alexander

Michael Alexander has been fascinated by the macabre since childhood, sparking a lifelong love affair with the horror genre. Hailing from Ontario, Canada, Michael's upbringing steeped his imagination in the eerie allure of the paranormal, the mysterious, the unusual, and the strange.


When he's not crafting chilling tales, Michael can often be found indulging in his passion for horror cinema, immersing himself in the dark narratives that fuel his creativity. Alternatively, he works with esteemed filmmakers in the industry. You could also spot him wandering amidst the tranquility of nature, accompanied by his beloved dog, Zeke.

More by Michael Alexander

Why Readwise Books?

Readwise Books is an ebook & audiobook platform that automatically logs how much you and your friends read, making it fun and easy to read more. Learn more →