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 |
All times are GMT +1. The time now is 01:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com