hi all, i am facing a weird problem here.. Currently doing a project using the excel solver. Due to so of the constraints, I need to define the solver model in VBA code. (Note: saving the model then load it cannot fulfill all my constraints in my project.) Ok, now come to the problem:
(I have already set the reference to solver.xla)
1. Realised the SolverAdd, SolverDelete and SolverOk cannot work in my code.. I have follow exactly the syntax
Example: SolverAdd cellref:="E4:H4", relation:=1, formulatext:="$E$58:$H$58"
After I run it, then i check from the solver(in excel worksheet: Tool->Solver). I can't find this constraint was added there?!! As what i understanding, it should be there until I reset it.
1. I start my project in MS Office 2000, but when I run the workbook in MS Office XP, it give me error message:something like "internal error or run out of memory". But i check the memory status, it still got quite a lot available.. that pc is run under 256 RDRAM . So the question is, VBA Solver function got problem when runing in different version of excel??
Try to seek around for quite a long time, but still can't solve the problem. Any expert in this forum pls alight me. Thank for million.