HsSetText

Data sources: Financial Management

HsSetText sends cell text to a data source. You can use all dimension members, cell references, the default POV, or a combination of all three.

Syntax

HsSetText(“Cell Text Comments”,”Connection;POV”)

Example

In this example, HsSetText sends the text from cell H3 to the HFM01 application.

HsSetText(“H3”,”HFM01;Scenario#Actual;Year#2004;Period#"&B$2&";View#<Scenario View>;Entity#UnitedStates.Connecticut;Value#<Entity Currency>;Account#"&$A3&";ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None];Custom4#
Increases")