Using the “record macro” icon in Excel to record the solver process, I had a couple of problems:

• When I tried to run the recorded macro, I got the message “Compile Error – Sub or Function not defined”.
• When that was fixed the solver worked, but stopped on the final solver screen, rather than returning to the spreadsheet.

The solutions to these problems and many more are given in a detailed article by John Peltier:

Using Solver in Excel VBA

The end result of my work, including open source code, will be covered in my next post.