Export (0) Print
Expand All

OLE Programmatic Identifiers

Office 2007

You can use an OLE programmatic identifier (sometimes called a ProgID) to create an Automation object. The following tables list OLE programmatic identifiers for ActiveX controls, the 2007 Microsoft Office applications, and Microsoft Office Web Components.

ActiveX Controls

Microsoft Access

Microsoft Excel

Microsoft Graph

Microsoft Office Web Components

Microsoft Outlook

Microsoft PowerPoint

Microsoft Word

ActiveX Controls

To create the ActiveX controls listed in the following table, use the corresponding OLE programmatic identifier.

To create this controlUse this identifier
CheckBoxForms.CheckBox.1
ComboBoxForms.ComboBox.1
CommandButtonForms.CommandButton.1
FrameForms.Frame.1
ImageForms.Image.1
LabelForms.Label.1
ListBoxForms.ListBox.1
MultiPageForms.MultiPage.1
OptionButtonForms.OptionButton.1
ScrollBarForms.ScrollBar.1
SpinButtonForms.SpinButton.1
TabStripForms.TabStrip.1
TextBoxForms.TextBox.1
ToggleButtonForms.ToggleButton.1

Microsoft Access

To create the Microsoft Access objects 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 available on the computer where the macro is running.

To create this objectUse one of these identifiers
ApplicationAccess.Application
CurrentDataAccess.CodeData, Access.CurrentData
CurrentProjectAccess.CodeProject, Access.CurrentProject

Microsoft Excel

To create the Microsoft Excel objects 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 available on the computer where the macro is running.

To create this objectUse this identifierComments
ApplicationExcel.Application
WorkbookExcel.AddIn
WorkbookExcel.ChartReturns a workbook containing two worksheets; one for the chart and one for its data. The chart worksheet is the active worksheet.
WorkbookExcel.SheetReturns a workbook with one worksheet.

Microsoft Graph

To create the Microsoft Graph objects 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 available on the computer where the macro is running.

To create this objectUse this identifier
ApplicationMSGraph.Application
ChartMSGraph.Chart

Microsoft Office Web Components

To create the Microsoft Office Web Components objects 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 Microsoft Office Web Components available on the computer where the macro is running.

To create this objectUse one of these identifiers
ChartSpaceOWC.Chart
DataSourceControlOWC.DataSourceControl
ExpandControlOWC.ExpandControl
PivotTableOWC.PivotTable
RecordNavigationControlOWC.RecordNavigationControl
SpreadsheetOWC.Spreadsheet

Microsoft Outlook

To create the Microsoft Outlook object given 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 available on the computer where the macro is running.

To create this objectUse this identifier
ApplicationOutlook.Application

To create the ActiveX controls that are specific for Outlook forms, as listed in the following table, use the corresponding OLE programmatic identifier.

To create this Microsoft Office Outlook controlUse this identifier
OlkBusinessCardControlOutlook.OlkBusinessCardControl
OlkCategoryOutlook.OlkCategoryStrip
OlkCheckBoxOutlook.OlkCheckBox
OlkComboBoxOutlook.OlkComboBox
OlkCommandButtonOutlook.OlkCommandButton
OlkContactPhotoOutlook.OlkContactPhoto
OlkDateControlOutlook.OlkDateControl
OlkFrameHeaderOutlook.OlkFrameHeader
OlkInfoBarOutlook.OlkInfoBar
OlkLabelOutlook.OlkLabel
OlkListBoxOutlook.OlkListBox
OlkOptionButtonOutlook.OlkOptionButton
OlkPageControlOutlook.OlkPageControl
OlkSenderPhotoOutlook.OlkSenderPhoto
OlkTextBoxOutlook.OlkTextBox
OlkTimeControlOutlook.OlkTimeControl
OlkTimeZoneControlOutlook.OlkTimeZone

Microsoft PowerPoint

To create the Microsoft PowerPoint object given 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 available on the computer where the macro is running.

To create this objectUse this identifier
ApplicationPowerPoint.Application

Microsoft Word

To create the Microsoft Word objects 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 available on the computer where the macro is running.

To create this objectUse one of these identifiers
ApplicationWord.Application
DocumentWord.Document, Word.Template
GlobalWord.Global



Community Additions

ADD
Show:
© 2014 Microsoft