VII.4.3.1 “DbAndLoadCases” VBA module

This module is closely related to the definition of databases and load cases. It manages the recovery of information needed to create the databases, and to generate and read the Results corresponding to the different load cases. Several variables corresponding to the lists of databases, elementary and combined load cases are defined in the module. For example:

• “appName” allows to retrieve the appropriate version of FeResPost. When you change the version of FeResPost COM server, you have to modify the variable.
• “storageMaxCapacity” is a “Double” variable that corresponds to the size in Megabytes of the buffer that stores information read from XDB attachments.
• “maxNbrDataBases” contains the maximum number of databases that can be managed simultaneously by the excel project. Keeping the value low will reduce the use of memory by excel.
• “maxNbrAttachments” corresponds to the maximum total number of attachments allowed in the project. Here again, the tuning of that value allows to reduce the amount of memory used by excel.

Also this module provides functions that allow to retrieve Results or load case information. Several such functions deserve more explanation:

• “getCurrentDb” returns the currently active database corresponding to the currently selected load case name.
• “getResults” is used to extract Results, or build them by calculating linear combinations.
• “getParameter” is used to retrieve a parameter associated to the currently selected load case. (Arguments are the name of the currently selected load case, and the name of the parameter.)

These methods are mentioned here because they are used in “ExtractCriteria” module to program post-processing operations. The user that wishes to modify the post-processing criteria will use these functions.