SetTextCellsLineItems

Appends or updates line items for the specified cells. Line item data is passed in a String array.

Tip:	To update cells by passing data in a Double array, use SetCellsLineItems.

The cells’ dimension members are passed in arrays that have a one-to-one correspondence with each other.

Syntax

<HsvData>.SetTextCellsLineItems varalScenario, varalYear, varalPeriod, varalEntity, varalAccount, varalICP, varalCustom1, varalCustom2, varalCustom3, varalCustom4, varabstrData, varabstrDetail

Argument	Description
varalScenario	Long array (ByVal). The member IDs of the cells' Scenario dimension members.
varalYear	Long array (ByVal). The member IDs of the cells' Year dimension members.
varalPeriod	Long array (ByVal). The member IDs of the cells' Period dimension members.
varalEntity	Long array (ByVal). The member IDs of the cells' Entity dimension members.
varalAccount	Long array (ByVal). The member IDs of the cells' Account dimension members. Tip: Use HsvAccounts.UsesLineItems to check whether an account supports line items.
varalICP	Long array (ByVal). The member IDs of the cells' Intercompany Partner dimension members.
varalCustom1	Long array (ByVal). The member IDs of the cells' Custom 1 dimension members.
varalCustom2	Long array (ByVal). The member IDs of the cells' Custom 2 dimension members.
varalCustom3	Long array (ByVal). The member IDs of the cells' Custom 3 dimension members.
varalCustom4	Long array (ByVal). The member IDs of the cells' Custom 4 dimension members.
varabstrData	String array (ByVal). The data to be added to the cells, formatted according to the user’s preferences.
varabstrDetail	String array (ByVal). The line item descriptions that identify the line item details to be updated.

Example

The following example adds data for two line items. The example assumes that the member ID arrays passed to SetTextCellsLineItems have been previously set.

Dim saDesc(1) As String, saData(1) As String
saData(0) = "100000"
saData(1) = "200000"
saDesc(0) = "Chairs"
saDesc(1) = "Desks"
m_cHsvData.SetTextCellsLineItems laScen, laYr, laPer, laEnt, _ 
laAcct, laIcp, laCust1, laCust2, laCust3, laCust4, _ 
saData, saDesc