Thread: Solver 32.dll
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Solver 32.dll

sounds like you need to create a reference to solver in the VBE using
Tools=References.

http://support.microsoft.com/support...ver/solver.asp
Creating Visual Basic Macros that Use Microsoft Excel Solver

--
Regards,
Tom Ogilvy

"velero" wrote in message
...
Hi everybody

I am looking for some help. I have created a macro for
running solver. It worked for a while, but now I have the
following message.

Solver 32.dll is not available. You could define and edit
the model but you will not be able to solve it. For
fixing this go back and execute Excel for reinsetalling
the Solver.

If I first of all open a new file, set up a model and run
Solver, and then open my file and run the solver, it
works!! Whay not when I do it for the first time?

Any help would be appreciated, write to my email if you
prefer.

Regards
Velero