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

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

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/solver
/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


.

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


.

.

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


.

.

tom

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

Thanks
Velero

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


.

.



.

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.

--
Regards,
Tom Ogilvy

wrote in message
...
tom

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

Thanks
Velero

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


.

.



.