View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ar164ts ar164ts is offline
external usenet poster
 
Posts: 1
Default 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