Breadcrumbs

EXPANDCONNECTIONRANGE

Overview

The EXPANDCONNECTIONRANGE function lets you retrieve a list of all Velixo connections within the workbook. 

Syntax 

=EXPANDCONNECTIONRANGE(
    ConnectionName, 
    ErpType,
    IncludeType
)

Arguments

Argument

Required/Optional

Description

ConnectionName

Optional

Search expression for filtering connection names, supports Velixo filtering techniques.

ErpType

Optional

Limits results to the provided ERP types.

Accepts the following values:

  • acumatica - Acumatica, MYOB Acumatica, Cegid XRP Flex, Haufe X360, Hotel Investor Apps, Jamis Prime

  • intacct - Sage Intacct

  • bc - Microsoft Dynamics 365 Business Central

  • stack - STACK

IncludeType

Optional

Include connection types in the results – TRUE or FALSE.

Default value: FALSE

Examples

List all connections and their types 

=EXPANDCONNECTIONRANGE(
    ,
    ,
    "TRUE"
)
image-20260623-090833.png

Description:

Returns all connection names for the workbook along with their ERP types.

List all connections of one type 

=EXPANDCONNECTIONRANGE(
    ,
    "acumatica"
)
image-20260623-091117.png

Description: Returns all connection names for the ERP of type Acumatica.

List all connections of one type 

=EXPANDCONNECTIONRANGE(
    ,
    "intacct"
)
image-20260623-091411.png

Description: Returns all connection names for the ERP of type Sage Intacct.

List all connections of one type 

=EXPANDCONNECTIONRANGE(
    ,
    "bc"
)
image-20260623-094026.png

Description: Returns all connection names for the ERP of type Business Central.