How do I create a macro that will activate the solver?
I am not making progress and there for I am asking you guys if you have som
solver macro written on your pc if you could send me the whole programing?
I would be very grateful for that
thanks
Hjalti
"Fredrik Wahlgren" wrote:
"Hjalti" wrote in message
...
I have tried to record this and been exploring the help in Visual Basic
but
nothing that I find is working.. The macro debugger always stops at the
solver line reports this message " Compile error: Sub or function not
defined"
Best regards
Hjalti
from Iceland
Is this what you want?
Sub Makro1()
AddIns("Solver").Installed = True
End Sub
In my version of Excel, the solver is called "Problemlösaren".
/Fredrik
|