|
|
OBJECT
Returns information from an object returned to the spreadsheet.
Syntax
OBJECT(range)
Range is a reference to a range object returned by a function such as CREATEOBJECT. It can be a nested function or a cell reference.
Example
Note The example shown uses a fictional ProgID and ServerName.
| A | Description (Result) | |
|---|---|---|
| 1 | =CREATEOBJECT("msn.marketdata", "\\investor") | Returns IDispatch object for stock data from the investor server. |
| 2 | =OBJECT($A$1).LastPrice("MSFT") | Returns last price of stock from information contained in object returned in cell A1. |