Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems migrating from EXcel 97 to Excel 2003
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.00000 1,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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 drawing objects problems in Excel 2007... | Excel Discussion (Misc queries) | |||
solver.xla problems migrating from Excel'97 to 2003 | Excel Programming | |||
Problems when using macro created in Excel 2000, in Excel 2003 | Excel Programming | |||
Migrating from Excel 2000 to Excel 2003 | Excel Discussion (Misc queries) | |||
Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) |