View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default 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...