This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Use an OLE programmatic identifier (sometimes called a ProgID) to create an Automation object. The following tables list OLE programmatic identifiers for ActiveX controls and the Office applications.
To create the ActiveX controls that are listed in the following table, use the corresponding OLE programmatic identifier.
| To create this control | Use this identifier |
|---|---|
| CheckBox | Forms.CheckBox.1 |
| ComboBox | Forms.ComboBox.1 |
| CommandButton | Forms.CommandButton.1 |
| Frame | Forms.Frame.1 |
| Image | Forms.Image.1 |
| Label | Forms.Label.1 |
| ListBox | Forms.ListBox.1 |
| MultiPage | Forms.MultiPage.1 |
| OptionButton | Forms.OptionButton.1 |
| ScrollBar | Forms.ScrollBar.1 |
| SpinButton | Forms.SpinButton.1 |
| TabStrip | Forms.TabStrip.1 |
| TextBox | Forms.TextBox.1 |
| ToggleButton | Forms.ToggleButton.1 |
To create the Microsoft Access objects that are listed in the following table, use one of the corresponding OLE programmatic identifiers. If you use an identifier without a version number suffix, you create an object in the most recent version of Access that is available on the computer where the macro is running.
| To create this object | Use one of these identifiers |
|---|---|
| Application | Access.Application |
| CurrentData | Access.CodeData, Access.CurrentData |
| CurrentProject | Access.CodeProject, Access.CurrentProject |
To create the Microsoft Excel objects that are listed in the following table, use one of the corresponding OLE programmatic identifiers. If you use an identifier without a version number suffix, you create an object in the most recent version of Excel that is available on the computer where the macro is running.
| To create this object | Use this identifier | Comments |
|---|---|---|
| Application | Excel.Application | |
| Workbook | Excel.AddIn | |
| Workbook | Excel.Chart | Returns a workbook that contains two worksheets; one for the chart and one for its data. The chart worksheet is the active worksheet. |
| Workbook | Excel.Sheet | Returns a workbook with one worksheet. |
To create the Graph objects that are listed in the following table, use one of the corresponding OLE programmatic identifiers. If you use an identifier without a version number suffix, you create an object in the most recent version of Graph that is available on the computer where the macro is running.
| To create this object | Use this identifier |
|---|---|
| Application | MSGraph.Application |
| Chart | MSGraph.Chart |
To create the Microsoft Outlook object that are listed in the following table, use one of the corresponding OLE programmatic identifiers. If you use an identifier without a version number suffix, you create an object in the most recent version of Outlook that is available on the computer where the macro is running.
| To create this object | Use this identifier |
|---|---|
| Application | Outlook.Application |
To create the ActiveX controls that are specific to the Outlook forms listed in the following table, use the corresponding OLE programmatic identifier.
| To create this Microsoft Office Outlook control | Use this identifier |
|---|---|
| OlkBusinessCardControl | Outlook.OlkBusinessCardControl |
| OlkCategory | Outlook.OlkCategoryStrip |
| OlkCheckBox | Outlook.OlkCheckBox |
| OlkComboBox | Outlook.OlkComboBox |
| OlkCommandButton | Outlook.OlkCommandButton |
| OlkContactPhoto | Outlook.OlkContactPhoto |
| OlkDateControl | Outlook.OlkDateControl |
| OlkFrameHeader | Outlook.OlkFrameHeader |
| OlkInfoBar | Outlook.OlkInfoBar |
| OlkLabel | Outlook.OlkLabel |
| OlkListBox | Outlook.OlkListBox |
| OlkOptionButton | Outlook.OlkOptionButton |
| OlkPageControl | Outlook.OlkPageControl |
| OlkSenderPhoto | Outlook.OlkSenderPhoto |
| OlkTextBox | Outlook.OlkTextBox |
| OlkTimeControl | Outlook.OlkTimeControl |
| OlkTimeZoneControl | Outlook.OlkTimeZone |
To create the Microsoft PowerPoint object that are listed in the following table, use one of the corresponding OLE programmatic identifiers. If you use an identifier without a version number suffix, you create an object in the most recent version of PowerPoint that is available on the computer where the macro is running.
| To create this object | Use this identifier |
|---|---|
| Application | PowerPoint.Application |
To create the Microsoft Word objects that are listed in the following table, use one of the corresponding OLE programmatic identifiers. If you use an identifier without a version number suffix, you create an object in the most recent version of Word that is available on the computer where the macro is running.
| To create this object | Use one of these identifiers |
|---|---|
| Application | Word.Application |
| Document | Word.Document, Word.Template |
| Global | Word.Global |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Training
Module
Build Office Add-ins for Word - Training
This module walks through development of Office Add-ins for Microsoft Word.
Certification
Microsoft Office Specialist: Access (Office 2016) - Certifications
Demonstrate that you have the skills needed to get the most out of Access 2016 by earning a Microsoft Office Specialist (MOS) certification.