CustomProperties Object
Excel Developer Reference |
A collection of CustomProperty objects that represent additional information. The information can be used as metadata for XML.
Remarks
Use the Properties property of the SmartTag object, or the CustomProperties property of the Worksheet object, to return a CustomProperties collection.
Once a CustomProperties collection is returned, you can add metadata to worksheets and smart tags depending on which you choose to work with.
To add metadata to a worksheet, use the CustomProperties property with the Add method.
Example
The following example demonstrates this feature. In this example, Microsoft Excel adds identifier information to the active worksheet and returns the name and value to the user.
Visual Basic for Applications |
---|
|
To add metadata to a smart tag, use the Properties property with the Add method.
The following example demonstrates this feature. In this example, Microsoft Excel adds a smart tag titled "MSFT" to cell A1, then adds extra metadata called "Market" with the value of "Nasdaq" to the smart tag and then returns the value of the property to the user. This example assumes the host system is connected to the Internet when running this code sample and the checked recognizer called "Stock Ticker Symbol Recognizer" is enabled for Microsoft Excel.
Visual Basic for Applications |
---|
|
See Also