Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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...
  #2   Report Post  
Posted to microsoft.public.excel.programming
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...


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why 39 sec. delay for simple commands, Excel 2003? Thanks! fmes Excel Discussion (Misc queries) 1 December 19th 09 02:10 PM
List of VBA Commands/Operators for Excel 2003 SP3 MichaelRobert Excel Worksheet Functions 2 September 18th 09 07:14 PM
CONVERTING Excel 2003 Commands to 2007 Ra Excel Discussion (Misc queries) 5 May 25th 09 01:36 PM
how to use my Excel 2003 DTF commands Ravi Manian Excel Worksheet Functions 1 July 11th 08 09:02 AM
use lotus 1-2-3 commands in excel 2003 Rik J Excel Worksheet Functions 3 February 10th 06 05:36 PM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"