xlm solver commands in excel 2003

A

aspo

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...
 
M

Myrna Larson

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

aspo

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top