Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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... |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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... |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why 39 sec. delay for simple commands, Excel 2003? Thanks! | Excel Discussion (Misc queries) | |||
List of VBA Commands/Operators for Excel 2003 SP3 | Excel Worksheet Functions | |||
CONVERTING Excel 2003 Commands to 2007 | Excel Discussion (Misc queries) | |||
how to use my Excel 2003 DTF commands | Excel Worksheet Functions | |||
use lotus 1-2-3 commands in excel 2003 | Excel Worksheet Functions |