Contact Us
Index
Version 5.0
Version 5.1 Version 5.2 Version 5.3 Version 5.4 Version 5.5 Version 5.6 Version 20.1 Version 20.2 Version 20.3 Version 20.4 Version 21.2 Version 21.3 Version 21.4 Version 22.1 Version 22.2 Version 22.3 Version 22.4 Version 23.1 Version 23.2 Version 23.3 Version 23.4 Version 24.1 Version 24.2 Version 24.4 Version 25.2 Version 25.4 Version 26.1 Version 26.2 Version 26.3
Contact Us
New Release Notification
Company Code Selection
User Profile
Excel Not Ready Error
Add-In Load Error
Multiple Instances
License Key Errors
Snapshot
Shared Templates Drive
Drive Types
File Server
SAP Database
Dropbox
Navigator
Create a File
Delete a File
Edit a File
Open a File
Common Options
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
System Administrator Options
System Administrator Licence Key
System Administrator User Permissions
System Administrator User Options
System Administrator Server Information
System Administrator Delimiter Options
System Administrator Configuration Options
Expand and Explode Level
Discover FICO Object Values
Expand and Explode
Expand FICO Object Values
Explode FICO Object Values
Explode FICO Object Value Hierarchy
Expand FICO Object Value Hierarchy
List of Values – Create
Previous FICO Object
Next FICO Object
Get Balance
Get CCA Balance
Get New GL Balance
Get Classic GL Balance
Get PCA Balance
Company Code Name
Alternative GL Account
FICO Object Description
Drill Criteria Sheets
Drill Criteria – Classic GL Balance
Drill Criteria – New GL Balance
Drill Criteria – PCA Balance
Drill Criteria – CCA Balance
Drill Using a Saved Template
Drill to Document
Drill to Line Item
Template Layout
Save Template Layout
Manage Templates
Other Tools
Hide Zeros
Clean Template
Configuration Sheet
GL Wand User Options
Load CCA
Create Schedule
Running the Scheduler
SMTP Email Settings
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Load and Validation
Execution

Help and Shortcuts

Accessing help 

You can access the product help by clicking on the help icon located under the Tools section on each product ribbon. Context sensitive help can be accessed by clicking on the help icon  located on each dialog. 

This product help is hosted by an internet service, to access the service users will require access to the following URL: https://docs.excel4apps.com

Keyboard shortcuts

Keyboard shortcuts help you save time by allowing you to never take your hands off the keyboard to use the mouse. Most dialog buttons can be pressed by using a shortcut key. To make the button shortcut keys for the active dialog appear press the ALT key. The underlined letter in each button’s text shows the mnemonic – the keyboard alternative – for each button. You can click a button by pressing the Alt key and the mnemonic. For example Alt-S would click the Save button on the Options dialog.

Mouse shortcuts

The following table contains a list of mouse shortcuts available on selected user interface components:

Buttons Component Action Definition
Right Click Text Box Pull down menu Access to Cut, Copy, Past, Undo, Redo and Select All functions.
Left and Right Table Columns Pull down menu Add, Add All, Remove and Remove All values from selected column.
Predefined Filter Table Pull down menu Quick access to defined filters and filter clear actions.
Left Click Tables Double Click Performs default component or dialog action e.g. select, open, execute, etc.

Filters

Some dialog search components implement a predefined filter to facilitate a quick and easy search. Search components providing a predefined filter displays a filter icon at the end of the search box: . Select the filter icon to display a list of predefined filters or clear a selected filter.