Using Logicim XLGL in a VBA macro

Visual Basic for Applications VBA

In visual basic for applications (VBA), you can call any Logicim XLGL worksheet function and a number of useful Logicim XLGL macros by using the Application.Run Excel command.

For example, you can get the balance of account 4010 using the Logicim XGL worksheet function:

Ensure to supply all parameters in the order specified in the documentation of each function. Empty arguments can be an empty string. For example, to get the total amount of all transactions in account 4010-0300, where 0300 is the department, you would use:

Predefined macros

Utilize the following commands to achieve actions normally done using the Logicim XLGL Ribbon:

1. Open the connection panel (to actually open a connection, use the XConnect worksheet function)

1. Open the report panel

1. Refresh the workbook

1. Recalculate the workbook

1. Freeze the active workbook

1. To prevent a confirmation message from being displayed, use

1. Freeze the active worksheet

1. To prevent a confirmation message from being displayed, use

1. Freeze the selected cell range

1. To prevent a confirmation message from being displayed, use

1. Open the drill-down window for the selected range

1. Hide rows and columns containing only zeros

1. Hide rows containing only zeros

1. Hide columns containing only zeros

1. Unhide rows and columns

1. Unhide rows

1. Unhide columns

1. Prepare print layout for active worksheet

1. Create a copy of the active worksheet

1. Switch language