OFFAUTMN.exe discusses Office 97 and 2000 Automation and provides sample code

This article has been archived. It is offered "as is" and will no longer be updated.
Offautmn.exe is a self-extracting executable that contains a white paper supplemented with sample projects that provide the fundamentals for understanding how to Automate Microsoft Office 97 and Microsoft Office 2000 applications.

The white paper is designed to guide you from the ground up to through creating a variety of fully functional Automation clients. It is structured as a tutorial with a large assortment of sample code and provides tips throughout that facilitate development of your Automation clients. Exercises and sample code are presented for Microsoft Visual Basic, Microsoft C/C++, and Microsoft Foundation Classes (MFC) developers.
More information
The following file is available for download from the Microsoft Download Center:
DownloadDownload the OffAutmn.exe package now.For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.


Automation, formerly called OLE Automation, is a technology that allows you to take advantage of an existing program's content and functionality, and to incorporate it into your own applications. Automation is based on the Component Object Model (COM). COM is a standard software architecture based on interfaces that is designed to separate code into self-contained objects, or components. Each component exposes a set of interfaces through which all communication to the component is handled.

With Automation, you can use the Microsoft Word mail merge feature to generate form letters from data in a database without the user being aware that Word is involved. You could even use all of the charting and data analysis functionality that Microsoft Excel provides using Automation. You don't need to write your own calculation engine to provide the multitude of mathematical, financial, and engineering functions that Excel provides; Instead, you can automate Microsoft Excel to "borrow" this functionality and incorporate it into your own application.

Automating Microsoft Office 97 and Office 2000 white paper

The white paper (Offautmn.doc) included in Offautmn.exe is intended to provide you with a foundation for developing your own Automation clients for Microsoft Office applications. A hands-on approach is used to help you with the following:
  • Understand how Office applications expose their content and functionality to Automation clients.
  • Identify the specific functions for the task you choose to Automate.
  • Locate the resources and documentation you need.
  • Understand how Automation works behind the scenes.
  • Create Automation clients with Visual Basic, Visual C++, and MFC.
  • Develop a client that uses the Automation server efficiently.
Each section in the white paper is supplemented with exercises and sample code that you can use to create complete and functional Automation clients for Office applications.

The supplemental projects for the exercises and samples that are included in Offautmn.exe are outlined below:
Project Description                Project Folder-------------------                --------------Exercise 2                         ..\VB\Exercise2Exercise 3                         ..\VB\Exercise3Using SAFEARRAYs                   ..\C++\SafeArrayDemoExercise 4                         ..\C++\Exercise4Exercise 5                         ..\C++\Exercise5Exercise 6                         ..\MFC\Exercise6Exercise 7                         ..\MFC\Exercise7Exercise 8                         ..\VB\Exercise8Exercise 9                         ..\MFC\Exercise9Exercise 10                        ..\VB\Exercise10Exercise 11                        ..\MFC\Exercise11Automate Excel to Create and Format a New Workbook              ..\VB\ExcelArray                                   ..\MFC\ExcelArraysAutomate Excel to Add Data froma DAO Recordset to a Workbook      ..\VB\ExcelData                                   ..\MFC\ExcelDataAutomate Word to Perform a MailMerge with Access Data             ..\VB\MailMerge                                   ..\MFC\MailMergeAutomate PowerPoint to Createand Run a SlideShow                ..\VB\SlideShow                                   ..\MFC\SlideShowAutomate an Office Application toObtain a Document's Properties     ..\VB\DocProps                                   ..\MFC\DocProps				
(c) Microsoft Corporation 2000, All Rights Reserved. Contributions by Lori Turner, Microsoft Corporation.

OFFAUTMN CreateDispatch GetActiveObject GetObject CreateObject Controller Invoke GetIDsOfNames Excel PowerPoint Word VB VC CLSID ProgID

Article ID: 253235 - Last Review: 01/12/2015 16:40:23 - Revision: 7.0

Microsoft Excel 2000 Standard Edition, Microsoft Visual Basic 5.0 Professional Edition, Microsoft Visual Basic 6.0 Professional Edition, Microsoft Visual Basic 5.0 Enterprise Edition, Microsoft Foundation Class Library 4.2, Microsoft Word 2000, Microsoft Word 97 Standard Edition, Microsoft Excel 97 Standard Edition, Microsoft PowerPoint 97 Standard Edition, Microsoft PowerPoint 2000 Standard Edition, Microsoft Access 97 Standard Edition, Microsoft Outlook 2000 Standard Edition, Microsoft Outlook 97 Standard Edition, Microsoft Outlook 98 Standard Edition

  • kbnosurvey kbarchive kbdownload kbautomation kbfile kbinfo kboutlookobj KB253235