HOST
Returns the container object that is hosting the Spreadsheet component. On a Web page this is the Internet Explorer document object. In a Visual Basic application, this is a reference to a Form object.
Syntax
HOST().[object].[property or method]
Example
=HOST().TextBox1.Value
In this example, HOST() returns Internet Explorer’s IHTMLDocument object, providing access to all of the information on the Web page. The “.” operator is then used to invoke the property “TextBox1” which returns a text box object. Finally, the “.” operator is used again to invoke the property “Value” which returns a text string containing the value of the text box.