Installing and Updating BfX

F o r u m

Home Ballistics for Excel Visit the BfX f o r u m
About BfX
Excel/VBA settings
Entering formulas
Drag functions
Robert Meijer

Adding an add-in to Excel is easy

For starters, check if your copy of Excel has had all updates. 

Excel 2003, 2007 and the 32 bits Excel 2010 and 2013 use the same version of BfX.xll. BfX.xll  automatically detects which version of Excel is runnung and adapts. The 64-bit version of Excel 2010 and 2013 use BfX64.xll.(what is an .xll file? Should you check it for virusses?)

Using the Installer

Most installations require the automatic installer. On these computers, auxilary files on which BfX.xll depends are not present. The installer puts BfX and some auxilary files from Microsoft on your computer. However, in the case they are already there (e.g. they came with another program or a previous installation of BfX)  then you could just swap the BfX.xll or the BfX64.xll for the newer one. That works fast, but you risk that the auxilary files from Microsoft are not updated.

Once installed you can easily check the installation. Just start Excel and  enter  =bfx_help() in a cell. When technically everything is allright one can start immediately (see right panel on this page) or download the Excel workbooks that illustrate the use of BfX. If you can't install BfX then start the trouble shooting here.

It is not nessecary to know all the ins and outs of add-in installation, but if you would like to know, start here


To uninstall BfX.xll or BfX64.xll, you simply delete BfX from Excels add-in list, close Excel, and delete BfX.xll or BfX64.xll from your computer.

Setup procedure

  1. Determine automatically the folder you want to put BfX.xll/BfX64.xll in. Download the Excel2003 workbook or the Excel2007/2010 workbook to find recommended default locations  automatically. These workbooks contain macros. Push the button on the worksheet to determine your recommended locations. Copy the locations (and paste them later).
    simply choose a location
    c:/Programs Files/BfX
  2. Download BfX (< 200kB). Use the  "Save" button to place it in the folder you have found or created in step 1.
    You can also download the installer programs for the
    32bit versions Excel2003, 2007, 2010 and 2013 or for the  64bit versions Excel2010 and 2013z. Extract them in the same folder:
    Option 1 
    you put them in a special folder where you can keep them as long as you use BfX. Then you can unistall BfX from this folder . 
    Option 2
    use a or the default folder and remove this folder afterwards. You have to uninstall BfX via the configuration panel. 
    Double click BfXSetup.exe or BfXSetup64.exe to install. Move or copy BfX.xll/BfX64.xll to the folder determined in step 1.

  3. Tell Excel where the .xll is
    Excel 2003 Excel 2007 Excel2010/2013
    Click on the "Tools menu", expand the menu if nessecary.
    Click the "Excel option" button that is located at the bottom of Excels start menu.

    Click Options

    Click "Add-Ins ..."

    Click "Add Ins" and then, check if manage "Excel Add Ins" is listed , then click "Go ...".

    Click Add-Ins

    Click Browse... and surf to the folder where you have stored BfX.xll. Select BfX.xll and click "Open".

    Click  Browse... and surf to the folder where you have stored BfX.xll. Select BfX.xll and click "Open".

    Click  Browse... and surf to the folder where you have stored BfX.xll or BfX64.xll. Select the BfX.xll or the  BfX64.xll and click "Open".

To check the installation

  1. Create a new worksheet.
  2. Enter in an empty cell =bfx_help(). BfX is not installed correctly when you get an error.
  3. To kick start, generate a table as displayed on the right pannel. Use =bfx_help(n)  where n=0, 1, 2, ..., to about 100. This generates a list and explanation of BfX functions.
  4. Additional information can be found via =bfx_help2(n)  where n=0, 1, 2, ..., to about 70. With bfx_help2 you generate a list of units and drag functions that is supported.
AFTER the installation of BfX.xll
To start using BfX withhout reading all the workbooks: use =bfx_help(n) where n=1, 2, to about 100

BfX has a built in help facility. Type =bfx_help(n) where n=0...about 100. The input on the left in Excel 2007 generates the output above. Use a fixed font like Courier New for the nicest layout.

Help in Excel 2003, generated with  =bfx_help(n) where n=0, 1,..., 17

When the installation goes wrong

Please follow the above procedure carefully. If you did not use the setup file method, use it now. If this does not help either, check the BfX Forum.