Tell us what's wrong and we'll take a look.
Thanks – we got it. We'll review and follow up if needed.
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 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
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.
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 →
Enter your email to continue. We'll create your account if you're new here.