Prev: how to brake a excel sheet passward
Next: Code in a macro to branch to another macro?
From: helene and gabor on 24 Apr 2010 08:58
Hello Öregjani

I am just learning the Solver business. Past exchange on the subject says
that your statement should be:

Application.Run "solver.xla!solverok", "B10",3,0,"B11"
meaning:
set cell:B10
MaxMinVal=3
valueOf=0
byChange:B11
the next two statements:
Result=Application.Run("solver.xla!solversolve",True)
Application.Run "solver.xla!solverfinish"


Jó szerencsét

Gabor Sebő


<Öregjani(a)discussions.microsoft.com> wrote in message
news:EEDADAB9-2EC2-4A38-98EE-9C6E9D074595(a)microsoft.com...
>I have programmed a workbook using solver in VBA code. Now I added a lot of
> other worksheets and data acquisition capabilities to the workbook, and
> cannot operate the solver from the VBA, but it works when I start it
> manually. The error message appears while setting the solver's option
> parameters. The solver is registered, the SoverReset command before the
> option parameter setting doesn't generate any error message. I have tried
> already insert the command Application.Run "Solver.xla!Auto_Open" into the
> Workbook_open part, but it didn't help. My OS is WinXP, my Excel is 2002
> SP3. In the mean time I've tried the workbook on an other computer with
> 1GB
> memory, but the error is the same.
>

 | 
Pages: 1
Prev: how to brake a excel sheet passward
Next: Code in a macro to branch to another macro?