xlm solver commands in excel 2003
 

Hi!

I'm trying to run my old excel 4.0 macro (xlm) in excel 2003. The only
problem is, that whenever there is a solver related command (SOLVER.RESET,
SOLVER.ADD etc.) in my syntax, I get the error message "Macro error at
cell...". I have activated "Solver Add-in" in Tools/Add-Ins menu. What else
should I do to get the good old macro work again, translating it to VBA is
too time-consuming at this point...

xlm solver commands in excel 2003
 

I don't now if this will help, but in the VB Editor, go to Tools/References
and be sure that Solver is checked.

On Tue, 16 Nov 2004 03:09:07 -0800, "aspo"
wrote:

Hi!

I'm trying to run my old excel 4.0 macro (xlm) in excel 2003. The only
problem is, that whenever there is a solver related command (SOLVER.RESET,
SOLVER.ADD etc.) in my syntax, I get the error message "Macro error at
cell...". I have activated "Solver Add-in" in Tools/Add-Ins menu. What else
should I do to get the good old macro work again, translating it to VBA is
too time-consuming at this point...

xlm solver commands in excel 2003
 

Solver -option was checked also under VB editor, however, thank for your
response.

I downloaded the "xlmacro.exe" from
office.microsoft.com/downloads/2000/Xlmacro.aspx to get XLM-help files, but
it - of course - was not willing to work under excel 2003. I'm afraid,
xlm-support is bit by bit disappearing...

If someone has succesfully run XLM macros containing SOLVER calls under
Excel 2003, please inform!


I don't now if this will help, but in the VB Editor, go to Tools/References
and be sure that Solver is checked.

On Tue, 16 Nov 2004 03:09:07 -0800, "aspo"
wrote:

Hi!

I'm trying to run my old excel 4.0 macro (xlm) in excel 2003. The only
problem is, that whenever there is a solver related command (SOLVER.RESET,
SOLVER.ADD etc.) in my syntax, I get the error message "Macro error at
cell...". I have activated "Solver Add-in" in Tools/Add-Ins menu. What else
should I do to get the good old macro work again, translating it to VBA is
too time-consuming at this point...