Solver 32.dll

V

velero

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
 
G

Guest

Tom

Well, thought that and I went to the Reference window in
the VBA, and click the Solver Box. But didnt work.

Thanks for your comment
Velero
 
V

velero_velero

Tom

I did it again, and you are right. But how can I set up
the Solver box automatically in the VBA reference?

Any light on that?

Thanks
Verlero
 
G

Guest

tom

If another user opens the file, would work for him also,
or does he have to activate the reference?

Thanks
Velero
 
T

Tom Ogilvy

The reference is stored with the file. If the solver.xla is located in a
different location on another machine then it would break the reference.
 
Top