Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver working intermittingly...tried some previously posted solut
Hi,
I am having issues with Solver -- my code is below. It only works with the code after running it manually -- and only when the same exact scenario being run by the code is executed manually first (if I run Solver manually for a scenario which is completely different than the scenario in the code, the code still does not work). There is no error coming up, it just completes with no output. I tried putting in the statement directly below into my code (saw this suggestion in another post), but this does not correct the issue. Application.Run "Solver.xla!Solver.Solver2.Auto_open" Any idea on how I can resolve this? Thanks ahead of time! ' In the scenario I've been testing, "holdclearsumprod" ='Transaction Summary'! _ $AK$1, cell AK1 = sumproduct(L2:L5,AJ2:AJ5), "holdclearbin" ='Transaction _ Summary'!$AJ$2:$AJ$5 Sheets("Transaction Summary").Activate SolverOk SetCell:="holdclearsumprod", MaxMinVal:=3, ValueOf:="=AL1", _ ByChange:="holdclearbin" SolverAdd CellRef:="holdclearbin", Relation:=5, FormulaText:="binary" SolverSolve userfinish:=True -- Robert |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver working intermittingly...tried some previously posted solut
HI. I am only guessing here. You are only changing Binary Cells somewhere,
and eventually they make their way to the Target Cell: ie sumproduct(L2:L5,AJ2:AJ5), Make sure you are not using such functions as IF( ) , ABS(), or Lookup() anywhere in your model. Again, just a guess. -- Dana "robs3131" wrote in message ... Hi, I am having issues with Solver -- my code is below. It only works with the code after running it manually -- and only when the same exact scenario being run by the code is executed manually first (if I run Solver manually for a scenario which is completely different than the scenario in the code, the code still does not work). There is no error coming up, it just completes with no output. I tried putting in the statement directly below into my code (saw this suggestion in another post), but this does not correct the issue. Application.Run "Solver.xla!Solver.Solver2.Auto_open" Any idea on how I can resolve this? Thanks ahead of time! ' In the scenario I've been testing, "holdclearsumprod" ='Transaction Summary'! _ $AK$1, cell AK1 = sumproduct(L2:L5,AJ2:AJ5), "holdclearbin" ='Transaction _ Summary'!$AJ$2:$AJ$5 Sheets("Transaction Summary").Activate SolverOk SetCell:="holdclearsumprod", MaxMinVal:=3, ValueOf:="=AL1", _ ByChange:="holdclearbin" SolverAdd CellRef:="holdclearbin", Relation:=5, FormulaText:="binary" SolverSolve userfinish:=True -- Robert |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver working intermittingly...tried some previously posted s
Hi Dana,
I'm not using the functions you listed. Thank for your input though. I still don't know what the issue is. Thanks, Robert -- Robert "Dana DeLouis" wrote: HI. I am only guessing here. You are only changing Binary Cells somewhere, and eventually they make their way to the Target Cell: ie sumproduct(L2:L5,AJ2:AJ5), Make sure you are not using such functions as IF( ) , ABS(), or Lookup() anywhere in your model. Again, just a guess. -- Dana "robs3131" wrote in message ... Hi, I am having issues with Solver -- my code is below. It only works with the code after running it manually -- and only when the same exact scenario being run by the code is executed manually first (if I run Solver manually for a scenario which is completely different than the scenario in the code, the code still does not work). There is no error coming up, it just completes with no output. I tried putting in the statement directly below into my code (saw this suggestion in another post), but this does not correct the issue. Application.Run "Solver.xla!Solver.Solver2.Auto_open" Any idea on how I can resolve this? Thanks ahead of time! ' In the scenario I've been testing, "holdclearsumprod" ='Transaction Summary'! _ $AK$1, cell AK1 = sumproduct(L2:L5,AJ2:AJ5), "holdclearbin" ='Transaction _ Summary'!$AJ$2:$AJ$5 Sheets("Transaction Summary").Activate SolverOk SetCell:="holdclearsumprod", MaxMinVal:=3, ValueOf:="=AL1", _ ByChange:="holdclearbin" SolverAdd CellRef:="holdclearbin", Relation:=5, FormulaText:="binary" SolverSolve userfinish:=True -- Robert |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver working intermittingly...tried some previously posted s
Hi,
Just wondering if anyone has any suggestions? This problem is not resolved. Thanks, -- Robert "robs3131" wrote: Hi Dana, I'm not using the functions you listed. Thank for your input though. I still don't know what the issue is. Thanks, Robert -- Robert "Dana DeLouis" wrote: HI. I am only guessing here. You are only changing Binary Cells somewhere, and eventually they make their way to the Target Cell: ie sumproduct(L2:L5,AJ2:AJ5), Make sure you are not using such functions as IF( ) , ABS(), or Lookup() anywhere in your model. Again, just a guess. -- Dana "robs3131" wrote in message ... Hi, I am having issues with Solver -- my code is below. It only works with the code after running it manually -- and only when the same exact scenario being run by the code is executed manually first (if I run Solver manually for a scenario which is completely different than the scenario in the code, the code still does not work). There is no error coming up, it just completes with no output. I tried putting in the statement directly below into my code (saw this suggestion in another post), but this does not correct the issue. Application.Run "Solver.xla!Solver.Solver2.Auto_open" Any idea on how I can resolve this? Thanks ahead of time! ' In the scenario I've been testing, "holdclearsumprod" ='Transaction Summary'! _ $AK$1, cell AK1 = sumproduct(L2:L5,AJ2:AJ5), "holdclearbin" ='Transaction _ Summary'!$AJ$2:$AJ$5 Sheets("Transaction Summary").Activate SolverOk SetCell:="holdclearsumprod", MaxMinVal:=3, ValueOf:="=AL1", _ ByChange:="holdclearbin" SolverAdd CellRef:="holdclearbin", Relation:=5, FormulaText:="binary" SolverSolve userfinish:=True -- Robert |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver working intermittingly...tried some previously posted s
Hi all,
I seem to have corrected the problem. FYI - I did the following two things and now it's working: 1 - I used the solution listed under "Preparing Solver for First Use" which is at the bottom of the following web page (Peltier Technical Services) -- specifically, I added the function that was listed here and called it on the "Woorkbook" "Open" event. http://peltiertech.com/Excel/SolverVBA.html 2 - I changed the following in my code listed below: From: ValueOf:="=AL1", To: ValueOf:=Range("AL1").Value, Hope this helps anyone having the same problem! -- Robert "robs3131" wrote: Hi, Just wondering if anyone has any suggestions? This problem is not resolved. Thanks, -- Robert "robs3131" wrote: Hi Dana, I'm not using the functions you listed. Thank for your input though. I still don't know what the issue is. Thanks, Robert -- Robert "Dana DeLouis" wrote: HI. I am only guessing here. You are only changing Binary Cells somewhere, and eventually they make their way to the Target Cell: ie sumproduct(L2:L5,AJ2:AJ5), Make sure you are not using such functions as IF( ) , ABS(), or Lookup() anywhere in your model. Again, just a guess. -- Dana "robs3131" wrote in message ... Hi, I am having issues with Solver -- my code is below. It only works with the code after running it manually -- and only when the same exact scenario being run by the code is executed manually first (if I run Solver manually for a scenario which is completely different than the scenario in the code, the code still does not work). There is no error coming up, it just completes with no output. I tried putting in the statement directly below into my code (saw this suggestion in another post), but this does not correct the issue. Application.Run "Solver.xla!Solver.Solver2.Auto_open" Any idea on how I can resolve this? Thanks ahead of time! ' In the scenario I've been testing, "holdclearsumprod" ='Transaction Summary'! _ $AK$1, cell AK1 = sumproduct(L2:L5,AJ2:AJ5), "holdclearbin" ='Transaction _ Summary'!$AJ$2:$AJ$5 Sheets("Transaction Summary").Activate SolverOk SetCell:="holdclearsumprod", MaxMinVal:=3, ValueOf:="=AL1", _ ByChange:="holdclearbin" SolverAdd CellRef:="holdclearbin", Relation:=5, FormulaText:="binary" SolverSolve userfinish:=True -- Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver not working | Charts and Charting in Excel | |||
Solver not working for me | Excel Programming | |||
Previously Posted...Need Help! | Excel Programming | |||
Solver Macro quit working | Excel Programming | |||
Solver isn't working... | Excel Programming |