var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Solver Problems
I created a Macro in Excel 2002 as follows:
SolverOK SetCell:=Range("$b$4"), MaxMinVal:=1, ByChange:=Range("$e$6")
When I run the Macro I get the following message:
"An unexpected internal error occurred, or available memory was exhausted."
Please , how can I get around this?
I don't have access to my computer right now, but I think it has to do with how you are accessing Solver.
Running Solver Macro in Excel from Access
For some reason it now works when I run the Macro in Excel. However when I call the Macro from Access I get the same message as before.
.Visible = True
Set objWkb = objXl.Workbooks.Open(wname)
Set objSht = objWkb.Worksheets(sname)
k = 1
Do While Not .EOF
.Cells(k, 1) = dataset!code
.Cells(k, 2) = dataset!descrip
.Cells(k, 3) = dataset!num
k = k + 1
I would suggest that the best place to get more information/help on Solver is this site:
Solver problem solution
Thank you for the link.
I have solved the problem by inserting the following line in my Excel Macro. I can now run this Macro from Access.