Prev: PLAY RACE GAMES
Next: Running macros when multiple Excels are open
From: BEETAL on 30 May 2010 05:49
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
 | 
Pages: 1
Prev: PLAY RACE GAMES
Next: Running macros when multiple Excels are open