Extended Property

Microsoft Office Object Model

Extended Property

       

Sets or returns attributes added to the <SCRIPT> tag, with the exception of the LANGUAGE and ID attributes. Read/write String.

Remarks

Attributes are separated by spaces, the same as in HTML. You cannot pass the LANGUAGE attribute or the ID attribute by using the Extended property.

The Microsoft Office host application doesn’t provide any means of checking the syntax of passed attributes.

If you pass the LANGUAGE attribute in the Extended property, the <SCRIPT> tag receives two language settings, which causes a conflict.

If you pass an ID attribute in the Extended property and no ID has been set through either the ID parameter of the Add method or the Id property of the Script object, the ID is exported correctly.

Example

This example checks the Extended property to ensure that no additional attributes have been added to the first script in worksheet one in the active workbook.

If ActiveWorkbook.Worksheets(1).Scripts(1).Extended _
    <> "" Then
      MsgBox "This script contains extended attributes."
End If