Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Premium Solver Macro Problem
Hi all...
I have a problem when i record macro using premium solver. I have an input sheet where the user enters the data and clicks the solve button. the premium solver solves the optimisation problem and displays the result. when i tried to record the macro for the click operation. excel crashes.... I have added both the solver and premium solver references.. My code looks like this when i record... Code: Sub solve() ' Sheets("DataInput-Results").Select ' solve Macro ' Sheets("Model").Activate Dim prob As New Problem prob.Init ActiveSheet prob.Solver.Optimize Set prob = Nothing Sheets("DataInput-Results").Activate End Sub Please help me find the solution for this problem. Thanks Suji |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Substitute for Premium Solver? | Excel Discussion (Misc queries) | |||
premium solver education | Excel Discussion (Misc queries) | |||
Premium Solver does not work with Vista | Excel Worksheet Functions | |||
Binary integer non-linear programming excel solver premium | Excel Worksheet Functions | |||
Binary integer non-linear programming excel solver premium | Excel Worksheet Functions |