History

Addins>BioRailsUtilities>API

B4OUtilities-VBA

Like B40Utilities, the interface to the functionality has not yet been fixed, however it is provisionally documented here so that we can gain feedback to improve and extend the product. These pages describe how to include references to the B4OUtilities in your VBA project and how to use the functions with a worked example.

References - VBA Project BioRails_Utilities

Setting a reference to BioRails_Utilities

  1. Open the VBA Editor
    1. Open Excel
    2. Open the VBA Editor
      • alt-F11 or
      • Tools -> Macros... - Visual Basic Editor
    3. Select the project with which to use the utilities.
      • ctrl-R or
      • View -> Project Explorer
        1. Click on Project eg VBA Project(Book2)
  2. Add The Reference
    1. Tools --> References...
    2. Check the box for BioRails_Utilities

A new folder will appear in the VBA Project Explorer (if you are in folder view) called References and it will have an entry Refrence to BioRailsUtility.xla

Press 'F2' to open the object browser and select BioRails_Utiliies to browse the methods and properties available to you.

Also available in: HTML TXT