ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Converting mulitlingual .xls using solver.xla (https://www.excelbanter.com/excel-programming/285294-converting-mulitlingual-xls-using-solver-xla.html)

ar164ts

Converting mulitlingual .xls using solver.xla
 
Friend wrote an Excel spreadsheet using the solver, written for a
multi-lingual version of Office. The language used is Italian.

They now want to distribute the spreadsheet to their own customers, wh
will be using the plain-vanilla version of Office (2000/XP).
Problem is, the worksheet will not run on machines with vanilla-Office


I have already changed:
a. solver functions from Italian to English eg
from: SOLVER.XLA'!RISOLUTORE.RISOLVI()
to: SOLVER.XLA'!SOLVER.SOLVE()

b. macro definition of solver location
from: C:\Program Files\Microsoft
Office\Office\LIBRARY\Risolut\SOLVER.XLA
to C:\Program Files\Microsoft Office\Office\LIBRARY\SOLVER.XLA


The error is still the same, "insufficient data"

If anyone has any pointers/solutions, would appreciate it very much.

Thanks

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com