Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SOLVER Reset command does not work in 2007Excel why???? Two Questi
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move and reset valuse using a command Button | Excel Discussion (Misc queries) | |||
Last Cell Reset Command- Built In | Excel Discussion (Misc queries) | |||
Reset All Command Buttons on an Excel UserForm | Excel Programming | |||
Copying Formulas from One Worksheet to Another -- Very Easy Questi | New Users to Excel | |||
where to reset microsoft query allow edit command DDE | Setting up and Configuration of Excel |