![[Home]](images/bhome.gif){kind=small}
![[What's New]](images/bnews.gif){kind=small}
![[Products & Services]](images/bprdsrv.gif){kind=small}
![[Contents]](images/btoc.gif){kind=small}
![[Feedback]](images/bfeed.gif){kind=small}
![[Search]](images/bsrch.gif){kind=small}
![[Dividing Line Image]](div.gif){kind=small}
How does the new 1-2-3 Solver compare to
the one in Microsoft Excel?
If someone using Excel creates a Solver
model, can I solve it in 1-2-3?
If I create a 1-2-3 Solver model, can I
send it to someone who uses Excel?
We have an application in Visual Basic that
uses the Solver in Excel. Is there any way to move it to 1-2-3?
The new 1-2-3 Solver includes the latest enhancements to our standard spreadsheet Solvers, but doesn't include the speed and capacity enhancements and other new features of our Premium and Large-Scale LP Solvers. The Solver in 1-2-3 97/98 has the same features as the Solver in Excel 97, and it uses the same underlying algorithmic "engine."
Yes, with a couple of provisions: The Excel workbook must be saved in 1-2-3 WK4 format, using Excel 97 (earlier versions of Excel do not support transfer of Solver models). You must use the Save Model button in Excel to save the Solver problem specifications, and use the Load Model button in 1-2-3 to reload the problem specifications.
Yes, again with some provisions: The 1-2-3 workbook should be saved in WK4 format. You must use the Save Model button in 1-2-3 to save the Solver problem specifications, and use the Load Model button in Excel to reload the problem specifications.
This may well be feasible, though it may be easy or difficult, depending on the specific features your application uses to (i) create a user interface and (ii) manipulate the spreadsheet. The LotusScript language is compatible with Visual Basic Application Edition, and the Excel object model and the 1-2-3 object model have many overall similarities -- though there are also many detailed differences. The Solver application programming interface in LotusScript is similar to the API provided to Excel users in Visual Basic, though again there are some detailed differences. Most likely, your application's design could be preserved, but you would have to do some work to deal with the various differences.
Back to: Solver News or Solver FAQs