ParametersOutReady Event

The ParametersOutReady event occurs when a set of parameters is passed from a connected Web Part that implements the IParametersOutProvider interface to a Spreadsheet Web Part that implements the IParametersOutConsumer interface.

expression.ParametersOutReady(InterfaceName As String, ParamValues As Variant)

expression    Required. An expression that returns a Spreadsheet object.

InterfaceName   The name of the IParametersOutConsumer interface receiving the event (as defined in the solution specification file: InterfaceConnections/ParametersOutConsumer@Name).

ParamValues   An array of strings that contains the parameters provided by the Web Part implementing the IParametersOutProvider interface.

Remarks

This event applies only to a Spreadsheet Web Part on a Web Part Page on a SharePoint site. For more information on the Spreadsheet Web Part, search Excel help and the Microsoft Developer Network (MSDN) Web site.

The ParametersOutReady event fires when a separate Web Part that implements the IParametersOutProvider interface invokes the FireParametersOut method. The ParamValues parameter is an array of strings in which each string contains the value of a parameter. The ParamValues parameter must have the same length and order as the items listed in the IParametersOutProvider interface declaration. When this event fires, you can query the Web Part data source to get the updated data that has been sent to the data source by the Web Part that implements the IParametersOutProvider interface.