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