View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hjalti Hjalti is offline
external usenet poster
 
Posts: 2
Default 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