B
BEETAL
Private Sub CommandButton4_Click()
SolverReset
SolverAdd CellRef:="$B$8:$E$8", Relation:=3, FormulaText:="$B$9:$E$9"
SolverAdd CellRef:="$B$8:$E$8", Relation:=1, FormulaText:="$B$10:$E$10"
SolverAdd CellRef:="$F$8", Relation:=2, FormulaText:="100%"
SolverOk SetCell:="$J$6", MaxMinVal:=1, ByChange:="$B$8:$E$8"
SolverSolve userFinish:=True
SolverFinish KeepFinal:=1
End Sub
Cann't Find Project or Library. IT IS CLEARLY SHOWN THAT Solver.xlam is
referenced,which I have ensured. the Excel file was created by 2003 version.
I am opening it in 2007 and trying to run it through command button.
Qs 2 . Many of my old files 2003 Excel files have lost all its VBA codes
when I have tried to open it in 2007. It is depressing. Is there a patch
available?
Kind Regards
Bharat
SolverReset
SolverAdd CellRef:="$B$8:$E$8", Relation:=3, FormulaText:="$B$9:$E$9"
SolverAdd CellRef:="$B$8:$E$8", Relation:=1, FormulaText:="$B$10:$E$10"
SolverAdd CellRef:="$F$8", Relation:=2, FormulaText:="100%"
SolverOk SetCell:="$J$6", MaxMinVal:=1, ByChange:="$B$8:$E$8"
SolverSolve userFinish:=True
SolverFinish KeepFinal:=1
End Sub
Cann't Find Project or Library. IT IS CLEARLY SHOWN THAT Solver.xlam is
referenced,which I have ensured. the Excel file was created by 2003 version.
I am opening it in 2007 and trying to run it through command button.
Qs 2 . Many of my old files 2003 Excel files have lost all its VBA codes
when I have tried to open it in 2007. It is depressing. Is there a patch
available?
Kind Regards
Bharat