Installing and Updating BfX

F o r u m

Installing and adding an add-in to Excel is easy

For the 32-bits Excel your have to use the BfX.xll. The 64-bit version of Excel 2010 uses BfX64.xll.(what is an .xll file? Should you check it for virusses?)

If would follow the following procedure to install BfX.

1. find out if you need the BfX.xll or BfX64.xll add-in.
2. download the add-in one
3. move the add-in from your download folder to c:\BfX
4. Follow the procedure below to tell Excel where to find the add-in
5. Activate the add-in
   

You can put the add-in in another location. In that case a few of the workbooks you download from this site require do adapt the visual basic code to point out the add-ins location on your computer.

Using the Installer

Checking the installation

The installation can be checked by starting Excel and enter =bfx_help() in a cell. If it responds then all is fine. 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. 

Uninstall 

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).
   or
   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.
   or
   You can also download the zipped installer programs for Excel2003, 2007 and 2010 32 bit or Excel2010 64 bit. 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.msi or BfXSetup64.msi to install. Move or copy BfX.xll/BfX64.xll to the folder determined in step 1.
   
   
3. Tell Excel where the .xll is
   

   Open Excel

   Click Options

   Click Add-ins,

   Click Go ...

   then Browse...

   Find bfx(64), then ok

   BfXXll2015 shows up and is selected, press OK Done

   To check the installation, load an empty worksheet. Enter in the cells of column A  0,1,2,3.... and in column B  BfX_Help(A1) etc

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.

When the installation goes wrong