STEM help / Exchanging data

6.5.11 Working with absolute paths, or workbooks created prior to STEM 7.1

There are two important alterations which may be required if the model path or add-in installation paths differ from the original on the other computer.

If the spreadsheet interface contains the standard add-in control block defining the STEM installation and model paths (see 6.5.2 Configuring the STEM add-in custom toolbar), and the originator has defined absolute paths, then these must also be altered by the end-user to reflect the installation directory they have chosen. Prior to STEM 7.1 this was standard practice, whereas later versions support the more straightforward relative path concept.

If the installation path chosen by the end-user for the stem.xla add-in differs from that on the computer where the original spreadsheet interface was saved, then this will not matter if the workbook was created with the STEM 7.3 add-in. If the end-user first opens stem.xla, then the workbook will automatically adjust to use the add-in in its new location. Otherwise Excel will prompt the end-user to browse for the new add-in location.

STEM 7.3 uses a so-called VBA reference to bind the workbook to the add-in, instead of the Excel external link mechanism used by previous versions, which had to be altered manually by an end-user as described below. It may be simpler to remove these links from the original workbook and use the STEM 7.3 add-in to create the preferred VBA reference for future ease of use.

 

© Implied Logic Limited