XML Property

Microsoft Excel Visual Basic

Show All Show All

XML Property

ShowXML property as it applies to the SmartTag object.

Returns a String representing a sample of the XML that would be passed to the action handler. Read-only.

expression.XML

expression    Required. An expression that returns a SmartTag object.

ShowXML property as it applies to the XmlSchema object.

Returns a String representing the content of the specified schema.

expression.XML

expression    Required. An expression that returns a XmlSchema object.

Example

ShowAs it applies to the SmartTag object.

This example adds a smart tag to cell A1 and then displays the XML that would be passed to the action handler. This example assumes the host system is connected to the Internet.

Sub CheckXML()

    Dim strLink As String
    Dim strType As String

    ' Define SmartTag variables.
    strLink = "urn:schemas-microsoft-com:smarttags#StockTickerSymbol"
    strType = "stockview"

    ' Enable smart tags to be embedded and recognized.
    ActiveWorkbook.SmartTagOptions.EmbedSmartTags = True
    Application.SmartTagRecognizers.Recognize = True

    Range("A1").Formula = "MSFT"

    ' Display the sample of the XML.
    MsgBox Range("A1").SmartTags.Add(strLink).XML

End Sub