OLEObject.progID Property

  • Article
Excel Developer Reference

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

Syntax

expression.progID

expression   A variable that represents an OLEObject object.

Example

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

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

See Also