Combine Function

The CXL.Combine() function is used to allow cells to contain values for CXL parameters and combine them into one value for a CXL paramenter. The Options parameter is a good example which can have many values, and thus by using the CXL.Combine() function militiple options can be set up in cells and combined into one parameter value, as used in many of the wizard created sheets.

   Wizard: "Stock, Customer or Vendor Wizard" shows how to use the functions below. It's best to create a sheet using the wizard, to understand the use and possibilities.

Syntax: =CXL.Combine( CellValue1, CellValue2, ... )

Example

  Combine values for parameters: =CXL.Combine( D3, D4 )    more Combine Examples
  Returns "COMP_A, COMP_B" from cell ref D3 and D4
Takes an array of referances. Thus we can put values in cells, and combine them to make a list of values for CXL function parameters. Blank values are ignores
  to become: =CXL.CodesSpill( CXL.Combine( D3, D4 ), "GLCodesByHead" )

   Wizard: "Get GL Values Example Wizard" shows how to use the functions below. It's best to create a sheet using the wizard, to understand the use and possibilities.

Parameters:

Parameter Description
CompCode Single Company code
Short code assigned by Consolidated XL, or by you to identify your company
CellValues One or more cell values to combined to make a list
Blank values ignored