Sample Test Code

A set of sample test code modules can be found in the test folder of the repo. These examples automate solving each of the optimization problems in SOLVSAMP.XLS, which is distributed with MS Office Excel and can be found programmatically in:

Application.LibraryPath & "\..\SAMPLES\SOLVSAMP.XLS"

...which on many systems resolves to:

C:\Program Files\Microsoft Office\root\Office16\SAMPLES\SOLVSAMP.XLS

Import these test modules into the sample Workbook above, set a reference to the SolverWrapper DLL and then save SOLVSAMP.XLS to SOLVSAMP.XLSM.

The test modules will solve each problem without modification.