Once you create the reference, it should remain until you remove it.

--
Regards,
Tom Ogilvy

" wrote in
message ...
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

-----Original Message-----
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


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

http://support.microsoft.com/support.../content/solve
r
/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


.

.