View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default How do I create a macro that will activate the solver?


"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