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.4.5.
Open the Excel workbook.
Open the VBA editor: “Tools –> Macros –> Visual Basic Editor”, or more simply press “Alt+F11”.
In the VBA editor, you must reference the library. Go to “Tools –> References”, and select the appropriate version of the FeResPost COM server. In the list, the name of the COM server should look like “FeResPost 5.2.0 COM server”.
Once this has been done, you may save the Excel workbook so that the reference to the FeResPost library is “remembered” the next time you open the workbook.
If a FeResPost COM server is already referenced in the workbook the first time you open it (as will probably be the case with the workbook downloaded from the FeResPost website), you must first un-select the old reference to the FeResPost server before selecting the new one. You will have to perform this operation each time you install a new version of the 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 with the “ClaDbIds” spreadsheet of the workbook. The corresponding line looks like:
Const appName As String = "FeResPost_4_5_4.Application"