ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Solver32.dll unavailable error, use excel setup to reinstall (https://www.excelbanter.com/excel-programming/294352-solver32-dll-unavailable-error-use-excel-setup-reinstall.html)

Tbeek

Solver32.dll unavailable error, use excel setup to reinstall
 
Did not used to get this error. I have the following error popup when
go to Tools,Solver in a workbook.
"Solver32.dll is unavailable -- you will be able to... To fix this
please use Excel setup to reinstall Solver" OK box is only choice.

I recently found solver and I also use it in VBA, I have it reference
in this workbook, and in personal.xls, and in the new workbook
book.xlt template

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


Tbeek[_2_]

Solver32.dll unavailable error, use excel setup to reinstall
 
I found a fix at this url
http://www.google.com/groups?threadm...0a% 40phx.gbl

I put this in my sub just before SolverOK
Application.AddIns("Solver Add-in").Installed = False
Application.AddIns("Solver Add-in").Installed = True

But if you have any insite or comments please post them. Would love t
hear.

Thank

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


Tbeek[_7_]

Solver32.dll unavailable error, use excel setup to reinstall
 
Sorry for the premature post that it was fixed.
I have gotten the error again and this time I can't get rid of it.

Using Excel 2000 9.0.4402 SR-1, and Windows 2000 5.0.2195 SP

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



All times are GMT +1. The time now is 02:00 PM.

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