Edit

OLE programmatic identifiers (Office)

  • Article

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.

ActiveX Controls

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

Microsoft Access

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

Microsoft Excel

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.

Graph

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

Microsoft Outlook

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

Microsoft PowerPoint

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

Microsoft Word

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

Support and feedback

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.