Velixo recommends the use of Microsoft 365 for this feature. Experimentally, Excel 2010 or higher can be used. See the Prerequisites for additional information. |
Description
The EXPANDCOSTCODERANGE function returns all project cost codes within the specified range
Syntax
EXPANDCOSTCODERANGE(Connection, Range)The EXPANDCOSTCODERANGE function uses the following parameters (see our article on including multiple parameter values):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Range | Optional | The range of cost codes to include in the results |
Example
=EXPANDCOSTCODERANGE("Demo", "01300:01400")Description
Returns all project cost codes between 01300 and 01400 (inclusive).
Result
Applies to
GL Module