Repository files navigation

AccUnit - Test your Access/Excel VBA code

For more informations seeWiki andhttps://accunit.access-codelib.net/

How-to: Install-AccUnit

• For 32 and 64 Bit Office/Access
• Run COM regfree (withAccess Add-In orExcel Add-In)

• Run tests
  • Tests can started byAccess-Add-In orExcel 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

Examples see./examples/msaccess/

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