VII.2.1 Preparing the application

Before using the excel workbook, the FeResPost COM component must be referenced. This is done as follows:

• The COM component must have been properly installed as explained in section X.A.3.5.
• Then, open the excel workbook.
• Open in the VBA editor: “Tools –> macros –> VisualBasic Editor”, or more simply key in "Alt+F11".
• In VBA editor, you must reference the library. Go in “Tools –> References”, and select the appropriate version of FeResPost COM server. In the list, the name of the COM server should look like “FeResPost 5.0.7 COM server”.

Once this has been done, you may save the excel workbook so that the references to FeResPost library shall be “remembered” the next time you open the workbook.

If a FeResPost COM server is already referenced in the workbook when you open it the first time. (As it probably will be the case with the workbook you download from FeResPost web site.) You must first un-select the old reference to FeResPost server, before selecting the new one. You will have to perform this operation each time you install a new version of FeResPost COM server on your computer.

When you change the version of FeResPost, you must also modify the variable “appName” in the VBA code associated to “ClaDbIds” spreadsheet of the workbook. The corresponding line looks like: