Installing the Erlang Library for Excel

(Skip this section if you are installing Erlang Library for Excel for the first time.)  

To learn about version history for Erlang Library for Excel, click here.  

You can remove an earlier version of Erlang Library for Excel before installing a new version.   But you can also skip this step, because installing the new version will automatically remove the old version and all its associated files before installing the new files.  

Also, please install the new version in the same folder that you used for the earlier version.  (See step 4 below.)

1. Verify that your version of Excel is either Excel 2013 (32 bit), Excel 2013 (64 bit), Excel 2010 (32 bit), Excel 2010 (64 bit), Excel 2007, or Excel 2003.  Erlang Library for Excel may not work with other versions of Excel. 
2. Download the file ErlangLibrary.zip from the web site AbstractMicro.com
   (Note: if you are using Internet Explorer for the download, and the downloaded ZIP file is missing, truncated, or corrupt, then try the download in another browser such as Firefox, Google Chrome, or Apple Safari.  Microsoft has acknowledged that Internet Explorer has issues with downloading ZIP files.)
3. Extract the contents of ErlangLibrary.zip to a temporary folder.  The extracted items consist of these files:
       A_Erlang.msi
    ErlangLicense.pdf
    ErlangInstallation.pdf
    README-FIRST.txt
    setup.exe
4. Run setup.exe.  Supply the requested information.  If you are upgrading from a previous version of Erlang Library for Excel, then we recommend that you install the product in the same folder that you used for the earlier version.  Otherwise, your Excel workbooks that use the Erlang functions will contain broken links (this can be fixed, but it is an annoyance).
5. Setup has copied the following files
       A_Erlang.xla
    ErlangHelpFile.chm
    ErlangHelpWeb.lnk
    ErlangInstallation.pdf
    ErlangLicense.pdf
    InstallErlangAddin.xls
   to your hard drive, placing them in the folder that you specified in Step 4 while running setup.exe, usually
     C:\Program Files\AbstractMicro\Erlang.  
   or
     C:\Program Files (x86)\AbstractMicro\Erlang.  
   We call this folder the Application Folder.  Setup has also created a subfolder \helppages of the Application Folder, and has placed about 40 help files in this subfolder.  The \helppages subfolder is a self-contained help web site for Erlang Library for Excel.
   SUGGESTION: We recommend that you never place your own Excel workbooks or other user files in the Application Folder.  That folder should contain only the files were placed there by setup.exe.
6. Register A_Erlang.xla as an installed Add-In with Microsoft Excel, as follows (for an alternative method, see below):
   1. In Windows Explorer, navigate to the Application Folder (defined in step 5 of the instructions above).
   2. In this folder, open the Excel workbook named InstallErlangAddin.xls. 
      Note: This workbook contains macro code that begins executing as soon as the workbook opens.  Depending on your security settings, you may get a "macro warning" from Excel.  If so, enable macros in the workbook and tell Excel to always trust macros signed by Abstract Micro Systems.
   3. A wizard immediately begins executing.  Follow the prompts to complete the installation.  The workbook automatically closes after the Add-In installation finishes.

Another way to register the Add-In

Instead of the actions specified in step 6 of the installation instructions, you may use Excel's built-in menus to register A_Erlang.xla as an installed Add-In.  The exact sequence of steps varies according to your version of Excel.

In Excel 2003:

1. Open Excel 2003
2. Select menu option Tools|Add-Ins
3. Within the Tools|Add-Ins dialog in Excel, browse to the the Application Folder (defined in step 5 above)
4. Within the browse window, double-click A_Erlang.xla
5. Depending on your Excel security settings, you may now receive a security alert from Excel warning you that A_Erlang.xla contains macros from a publisher whom you have not yet chosen to trust.  If you receive the macro warning, then you should tell Excel to always trust macros signed by Abstract Micro Systems.
6. A small custom toolbar should appear when Excel installs the Erlang Library as an Add-In.  It has 4 buttons: "C", "SL", "W", and "?".  You may dock this toolbar in one of the toolbar areas in the Excel window.

In Excel 2007:

1. Open Excel 2007
2. Click the "Office Button" (the button in the upper left corner of the Excel window)
3. Click the Excel Options button
4. Click "Add-Ins"
5. Click the "Go..." button near the bottom of the Add-Ins window, to "Manage Add-Ins"
6. Click the "Browse..." button and navigate to the Application folder (defined in step 5 above)
7. Within the browse window, double-click A_Erlang.xla
8. Depending on your Excel security settings, you may now receive a security alert from Excel warning you that A_Erlang.xla contains macros from a publisher whom you have not yet chosen to trust.  If you receive the macro warning, then you should tell Excel to always trust macros signed by Abstract Micro Systems.

In Excel 2013 or Excel 2010 (32 bit or 64 bit):

1. Open Excel 2010
2. Click the "File" button near the upper left corner of the Excel window
3. Click the Options button (in the left panel of the window).
4. In the Excel Options window, click "Add-Ins"
5. Click the "Go..." button near the bottom of the Add-Ins window, to "Manage Add-Ins"
6. Click the "Browse..." button and navigate to the Application folder (defined in step 5 above)
7. Within the browse window, double-click A_Erlang.xla
8. Depending on your Excel security settings, you may now receive a security alert from Excel warning you that A_Erlang.xla contains macros from a publisher whom you have not yet chosen to trust.  If you receive the macro warning, then you should tell Excel to always trust macros signed by Abstract Micro Systems.

As mentioned above, the installation process places the following files in your Application Folder, which by default is C:\Program Files\AbstractMicro\Erlang\ or
C:\Program Files x86)\AbstractMicro\Erlang\