Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver statements XLM --- Excel 2003
Hi I still use many macros written over the years in the old XLM
language. For the most part they appear to work OK in the newest Excel version. The exception are the statements calling for Solver operations like Solver.OK, Solver.Solve, etc, they always cause error messages. Can someone please tell me if there is a different syntax for these that will work within XLM macros in Excel 2003? Alternatively, is there an easy way to translate an entire XLM macro into VB? I don't know VB and certainly don't have the time to learn it and then to re-write all the macros. All help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver statements XLM --- Excel 2003
There is no easy translation path. VBA operates fundamentally differently
than XLM macros. I have never seen anyone mention any type of automated translation facility. I rarely use Solver, but I think I recall someone saying the solver moved away from R1C1 addressing to A1 style. Again, that isn't authoritative information, but something you can try with a simple problem and see if that works. -- Regards, Tom Ogilvy " wrote: Hi I still use many macros written over the years in the old XLM language. For the most part they appear to work OK in the newest Excel version. The exception are the statements calling for Solver operations like Solver.OK, Solver.Solve, etc, they always cause error messages. Can someone please tell me if there is a different syntax for these that will work within XLM macros in Excel 2003? Alternatively, is there an easy way to translate an entire XLM macro into VB? I don't know VB and certainly don't have the time to learn it and then to re-write all the macros. All help would be greatly appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver statements XLM --- Excel 2003
Tom Ogilvy wrote: There is no easy translation path. VBA operates fundamentally differently than XLM macros. I have never seen anyone mention any type of automated translation facility. I rarely use Solver, but I think I recall someone saying the solver moved away from R1C1 addressing to A1 style. Again, that isn't authoritative information, but something you can try with a simple problem and see if that works. -- Regards, Tom Ogilvy Thanks for your reply, Tom. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 + Solver | Excel Worksheet Functions | |||
how do you use solver in excel 2003 | Excel Discussion (Misc queries) | |||
Solver and Excel 2003 | Excel Programming | |||
Excel 2003 + Solver + C# | Excel Programming | |||
Excel 2003 + Solver + C# | Excel Programming |