Rob Bovey

Stephen Bullen

A guide to the development aspects of Excel covers such topics as building add-ins, creating custom charts, using class modules, handling errors, controlling external applications, and programming with databases.

The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET

Professional Excel Development

Michael Alexander

John Green

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).

Excel 2007 VBA Programmer's Reference

Robert Rosenberg

Paul T. Kimmel

Describes how to maximize VBA usage in the Excel environement, covering such topics as using VB6 and VB.NET, using SQL to access data with ADO, interacting with other Office applications, and programming to the Windows API.

Excel 2003 VBA Programmer's Reference

Direct from the most respected authorities on Excel, this book will be the definitive guide to developing applications with Microsoft Excel.

The Definitive Guide to Developing Applications Using Microsoft Excel and VBA

What is this book about? VBA is the programming language for the Microsoft Office suite and many other applications. VBA gives you complete control of Excel, allowing you to do anything from automating Excel tasks to developing full applications, using Excel as the development environment. Excel 2002 is an important upgrade to the Office suite spreadsheet program. It shows Microsoft's commitment to moving Office to be a web-enabled productivity tool, a rich client for working with web-based data, with new features such as SmartTags and XML support. Based on the successful content and format of Excel 2000 VBA Programmer's Reference, this new edition has been fully updated for Excel 2002. The authors are all Excel MVPs, involved daily in supporting the Excel VBA programmer community. What does this book cover? The first part of the book introduces Excel and VBA, including a VBA primer. The second part offers thematic, succinct, and practical discussions of the features available to Excel VBA programmers, with real-world examples answering frequently asked questions. The third and final part is a complete reference to the Excel, VBE, and Common Office Object Models. Here are just a few of the things you'll learn in this edition: The entire Excel Object Model and the Common Office Object Model Working with PivotTables Accessing and manipulating data sources from Excel with ADO Programming the Visual Basic Editor (VBE) New features in Excel 2002, SmartTags, XML, and the Web Expanded references for Excel versions 97, 2000, and 2002 Who is this book for? This book not only caters for beginner- and intermediate-level programmers with its introductory coverage of VBA and Excel, but also provides advanced information for experienced Excel developers in later chapters and the reference.

Stephen Bullen

About

Books

Join the club