Erlang Library for Excel

Download     Contents

Installing the Erlang Library for Excel

System Requirements

Operating system: Windows XP, Windows Vista, Windows 7.

Microsoft Excel version: Excel 2003, Excel 2007, Excel 2010 (32 bit), or Excel 2010 (64 bit).

Security settings for your computer must allow you to install an Excel Add-In.

Where to get the software

Always download the Erlang Library for Excel directly from http://www.abstractmicro.com, the web site of Abstract Micro Systems.  This web site always has the latest version, and it is a free download with no registration requirement.

If you have a copy of the software, do not give it to others.  Ask them to download directly from http://www.abstractmicro.com

Read the license first

There is no charge for using the Erlang Library for Excel.  However, this product is neither public domain, nor freeware, nor shareware, nor open-source.  Before installing or using the Erlang Library for Excel you must read and agree to the End User License Agreement (EULA).  To read the license, click here.

Upgrading from an earlier version

(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.)

Installation Instructions

  1. Verify that your version of Excel is either Excel 2010 (32 bit), Excel 2010 (64 bit), Excel 2007, or Excel 2003.  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.  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 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.

File Descriptions

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\

File Name File Description
A_Erlang.xla Excel Add-In containing all code for Erlang Library for Excel
ErlangHelpFile.chm Help file for Erlang Library for Excel.  The extension .chm indicates that it is a "compiled HTML" help file. This file contains the entire help system in a single file. 
ErlangHelpWeb.lnk Shortcut to the HTML file index.htm located in the subfolder \helppages of the Application Folder.  Note: this shortcut file will probably appear simply as ErlangHelpWeb in the folder contents.  That is, the extension .lnk will not be shown.
ErlangInstallation.pdf Installation Instructions
ErlangLicense.pdf End User License Agreement (EULA)
InstallErlangAddin.xls Workbook containing macro code that automatically registers A_Erlang.xla as an installed Excel Add-In.  See Installation Instructions above.  This file is used only during the installation process.
\helppages Subfolder of the Application Folder containing about 40 HTML files, style sheets, and images for a self-contained help web site for Erlang Library for Excel.

Remarks

The compiled-HTML help file ErlangHelpFile.chm is not needed for normal operation of the Erlang Library for Excel.  The macro code in A_Erlang.xla sometimes opens HTML files in the \helppages subfolder of the Application Folder, so all of those HTML files are necessary for normal operation of the Erlang Library.  However, no code ever opens ErlangHelpFile.chm.  Furthermore, all of the help pages in ErlangHelpFile.chm are duplicates of HTML files in the \helppages folder.  Why then would you want to open ErlangHelpFile.chm?  Answer: you might enjoy using the table of contents and search features that Microsoft's HTML-help system provides.

Feedback

Please send an email about your experience with Erlang Library for Excel.  Has it been helpful?  Is the documentation adequate?  Any problems?  Are there missing features that you would like to see?  We read all emails and will reply to your questions and suggestions.

Abstract Micro Systems, Nashville, Tennessee
Contact Abstract Micro Systems