PublishObject.SourceType property (Excel)

Returns an 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 webpage, 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.

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

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.