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?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question