Share via

PublishObject.SourceType Property

  • Article
Excel Developer Reference

Returns a XlSourceType value that represents the type of item being published.

Syntax

expression.SourceType

expression   A variable that represents a PublishObject object.

Example

This example determines the unique name of the first chart (in the first workbook) saved as a Web page, and then it sets the Boolean variable blnChartFound to True. If no items in the document have been saved as Chart components, blnChartFound is False.

Visual Basic for Applications 
  blnChartFound = False
For Each objPO In Workbooks(1).PublishObjects
    If objPO.SourceType = xlSourceChart Then
        strFirstPO = objPO.Source
        blnChartFound = True
        Exit For
    End If
Next objPO

See Also