View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bandicoot Bandicoot is offline
external usenet poster
 
Posts: 4
Default Using Solver with Excel 2007 VBA

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?