This is the comprehensive and official reference documentation on OLE, revised to incorporate OLE enhancements and bring them in line with 32-bit Windows 95 and Windows NT. Volume 2 concentrates on OLE Automation, the revolutionary capability of OLE that makes it possible to manipulate an application's objects from outside the application.

Volume II introduces OLE Automation, the hot new capability that makes it possible to manipulate an application's objects from outside the application. This book is key to learning how to create applications that expose programmable objects, and how to create tools that access and manipulate objects. Includes a reference of Automation interfaces and tools.

Volume II introduces OLE Automation, the hot new capability that makes it possible to manipulate an application's objects from outside the application. This book is key to learning how to create applications that expose programmable objects, and how to create tools that access and manipulate objects. Includes a reference of Automation interfaces and tools.

Newly revised and expanded to include such topics as ActiveX controls, exposing and accessing ActiveX objects, Remote Automation, and Windows NT 4.0, "Automation Programmer's Reference" is the comprehensive and official reference documentation on Automation.

This kit offers complete information and tools to give users' applications universal data access. As a result of the reception of the OLE DB 1.0 SDK, customers are clamoring for printed copies of the "OLE DB Programmer's Reference". The "OLE DB 1.1 Programmer's Reference" includes minor enhancements and bug fixes to the 1.0 documentation, as well as a full index, not available in the previous version.

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

What is this book about? Excel 2003 VBA Programmer's Reference is an updated and expanded version of the two previous editions now with a reference section downloadable from the Web for easy perusal. The book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications for other users. The book starts with a primer chapter focused on bringing the readers up to speed with Excel and VBA. From there, the book expands to focus on major issues faced by advanced Excel users and developers. What does this book cover? In this book, you'll discover how to do the following: Set up applications and convert them to add-ins Package and distribute Excel applications Set up interaction with other Office applications and databases Program the VB Editor and use the Windows API Use VB6 and VB.NET with Excel Set up internationalization Advanced debugging and error handling techniques