This Add-In uses the following VBA techniques:
  • Class Factory
  • Dynamic Code generation ( needs VBE6.DLL VBE6EXT.OLB )
  • Dynamic Function Calls using TLI ( needs TLBINF32.DLL )
  • Access Unit Tests ( see http://accunit.access-codelib.net/ )

Installation

- Download the Benchmark Add-In
- In MS Access go to the Add-In Manger, click "Add..." and select the Benchmark.mda from your Download Folder

Usage

- Open the VBA Editor with Alt-F11
- Create a new Class Module and save it with a name ending on "_Bench"
- Create a "Public Sub" for each test case you would like to compare
- In the Access Add-In menue ( not the VBA Add-In menue ! ) you will find the entry "RunBenchmarks"

Last edited Aug 4, 2012 at 12:45 PM by Gugro, version 3

Comments

No comments yet.