AccUnit

AccUnit - Test your Access/Excel VBA code

For more informations see Wiki and https://accunit.access-codelib.net/

Installation

How-to: Install-AccUnit

Notes

• For 32 and 64 Bit Office/Access
• Run COM regfree (with Access Add-In or Excel Add-In)

Dev state

• Run tests
  • Tests can started by Access-Add-In or Excel Add-In
  • Tag filter: TestSuite.Add(...).Filter("abc,xyz").Run
  • Test filter: TestSuite.Add(...).SelectTests("xyz*").Run
  • CI/VCS support: start automated test run with AutomatedTestRun / AutomatedTestRunVCS (How‐to: Run tests with AccUnit‐Loader - CI/VCS support)
• Write tests
  • Row test available
  • Generate test classes with TestClassGenerator (write TestSuite.TestClassGenerator in VBA immediate window) (Video)
• Output test results
  • TestSuite with 'Debug.Print' output to VBE Immediate window
  • Output test results to log/text file
• Other features
  • Code coverage tests (Video)
• VBE add-in
  • Start tests via UI
  • Select tests to run
  • show test result in tree view
  • generate test procedures

Remarks

Examples see ./examples/msaccess/

If the DLL files are located in a network drive, it will not work.