Using Solver with Excel 2007 VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

It seems that Solver code such as Application.Run "solver.xla!solverreset"
has to be changed to Application.Run "solver.xlam!solverreset"
when using Excel 2007, even in "compatability mode".
With the 'xlam' file extension, will this code still work in Excel 2003 and
if not, is there any way to write a VBA project using solver that will work
in both Excel 2003 and Excel 2007?
 
Back
Top