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.