Installing the Erlang Library for Excel

1. Verify that your version of Excel is either Excel 2003 or Excel 2007.  Erlang Library for Excel does 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.
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 while running setup.exe, usually
     C:\Program Files\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.
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
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\