Execute Method
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Activates a smart tag action that is associated with the smart tag type on a cell.
expression.Execute
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example inserts a refreshable stock quote for the ticker symbol "MSFT" and it assumes the host system is connected to the Internet.
Sub ExecuteASmartTag()
Dim strAction As String
strAction = "Insert refreshable stock price"
' Enable smart tags to be embedded and recognized.
ActiveWorkbook.SmartTagOptions.EmbedSmartTags = True
Application.SmartTagRecognizers.Recognize = True
' Invoke a smart tag for the Microsoft ticker symbol.
With Range("A1")
.Formula = "MSFT"
.SmartTags( _
"urn:schemas-microsoft-com:office:smarttags#stockticker") _
.SmartTagActions(strAction).Execute
End With
End Sub