ProgId Property [Excel 2003 VBA Language Reference]

  • Article

Returns the programmatic identifiers for the object. Read-only String.

expression.ProgId

expression Required. An expression that returns one of the objects in the Applies To list.

Remarks

For more information about programmatic identifiers, see OLE Programmatic Identifiers .

Example

This example creates a list of the programmatic identifiers for the OLE objects on worksheet one.

rw = 0
For Each o in Worksheets(1).OLEObjects
    With Worksheets(2)
        rw = rw + 1
        .cells(rw, 1).Value = o.ProgId
    End With
Next

Applies to | AddIn Object | OLEFormat Object | OLEObject Object | SmartTagRecognizer Object