Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Solver with Excel 2007 VBA
Bandicoot
Simply check the version If Application.Version <12 'Do stuff for 2003 and before End if -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "Bandicoot" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 & Solver | Excel Discussion (Misc queries) | |||
Solver Add in at startup in excel 2007 | Setting up and Configuration of Excel | |||
Solver in Excel 2007 | Excel Programming | |||
Where is Solver in Excel 2007? | Excel Discussion (Misc queries) | |||
Solver in excel 2007 | Excel Discussion (Misc queries) |