How do I create a macro that will activate the solver?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hjalti said:
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
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Premium Solver Macro Problem 3
Excel 2007: Help creating a macro that will run Solver? 3
Solver Macro in Excel 2007 1
Activate the solver witin a macro 3
Solver with VBA 1
How to run Solver while viewing a graph? 10
Solver Compiler issue 2
Using the addin solver inside a macro 1

Back
Top