Problems migrating from EXcel 97 to Excel 2003

[Chris Wilkinson]

hi all,

I posted a similar post yesterday from my sisters house, but I am now at
work and can give more information about the problem.

At work, we are migrating from Win2000 to WinXP, and from Office '97 to
Office 2003. We have many Excel spreadsheets that use solver.xla - called
from a VBA macro. None of these work in Excel 2003 now. They do not cause an
error, simply nothing happens. Here is an example of the code used:

ActiveSheet.Unprotect
s = Application.LibraryPath & "\solver\solver.XLA"
On Error Resume Next
Workbooks.Open filename:=s
Application.ExecuteExcel4Macro String:="SOLVER.XLA!SOLVER.RESET()"
Application.ExecuteExcel4Macro
String:="SOLVER.XLA!SOLVER.OK(PLOT!R46C4,2,0,(PLOT!R13C12:R14C12))"
Application.ExecuteExcel4Macro
String:="SOLVER.XLA!SOLVER.OPTIONS(100,100,0.000001,FALSE,FALSE,2,1,1,0.05,TRUE)"
Application.ExecuteExcel4Macro
String:="SOLVER.XLA!SOLVER.OK(PLOT!R46C4,2,0,(PLOT!R13C12:R14C12))"
Application.ExecuteExcel4Macro String:="SOLVER.XLA!SOLVER.SOLVE()"
ActiveSheet.Protect

I trawled the internet and found a page on the Microsoft Support site that
describes well my problem. Here is the address:
http://support.microsoft.com/kb/821430
However, this refers to the problem being to do with Office 2000 SP-3. We
are using Office 2003 SP-2. Has the problem persisted all the way through to
Office 2003 SP-2?
My problem is that we have many hundreds of spreadsheets based on templates
that use the offending code. I do not want to have to manually go back and
change the code in them all, when I thought that that XLM macros were still
supported.

Thank you,
Chris