Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver error with Excel 2000?
Rob. I can't simulate that problem with Excel XP. If you find yourself
having to do it "manually," see if the following idea will correct it. I believe Solver does internally keep track of a flag called "AutoOpened" ' Your Solver Routine... If SOLVER.AutoOpened = False Then SOLVER.Auto_open End If ' Continue... -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "Rob Bovey" wrote in message ... Hi Dave, I've fixed a similar problem with Solver in the past by manually running its Auto_Open procedure in my VBA code before I do anything else with it. Not sure if this is the same bug or not, but you might give that a try. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Dave Collins" wrote in message ... Does anyone know what the fix is for knowledge base article 821430? It is the the Solver fix for using Office 2000 SP3 and the Solver addin. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver error with Excel 2000?
I'm experiencing the same problem as the original poster.
I tried what you suggested, but to no avail. Anybody have any idea where the patch? MS says one is out there, but you have to contact them if you want it now. I couldn't locate anything in the download center. -----Original Message----- Hi Dana, I can't repro the problem in XP either. It seems to be a 2000-only bug. And the solution doesn't make a lot of sense, because the Auto_Open procedure should have run when the Solver add-in was loaded. It just smelled like an initialization problem, though, so I tried explicitly running Auto_Open and it seemed to work. Filed under voodoo fixes. <g |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver error with Excel 2000?
On Mon, 4 Aug 2003 17:10:06 -0700, "Christian Restifo"
wrote in microsoft.public.excel.programming: I'm experiencing the same problem as the original poster. I tried what you suggested, but to no avail. Anybody have any idea where the patch? MS says one is out there, but you have to contact them if you want it now. I couldn't locate anything in the download center. I have the problem as described in http://support.microsoft.com/default...;en-us;821430: When you use Excel 2000 and you use the Solver add-in, you may experience the following symptoms: When you run a Microsoft Visual Basic for Applications (VBA) macro that starts the Solver add-in and that sets the problem parameters, no calculations occur or problem solving occurs. All computers are running Office V-9.0.6926 SP3, but this happens only on two machines. How does one obtain the patch advertised in that KB article? -- Michael Bednarek, IT Manager, Tactical Global Management Waterfront Pl, Brisbane 4000, Australia. "POST NO BILLS" http://mcmbednarek.tripod.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver error with Excel 2000?
On Mon, 4 Aug 2003 17:10:06 -0700, "Christian Restifo"
wrote in microsoft.public.excel.programming: I'm experiencing the same problem as the original poster. I tried what you suggested, but to no avail. Anybody have any idea where the patch? MS says one is out there, but you have to contact them if you want it now. I couldn't locate anything in the download center. I obtained the patch (Q821430) from MS PSS, and it solved the problem. Where to find MS's contact details? That seems to vary widely from country to country. Generally, from http://support.microsoft.com/common/international.aspx select your country, and there should be some link to the local telephone support. Good luck. -- Michael Bednarek, IT Manager, Tactical Global Management Waterfront Pl, Brisbane 4000, Australia. "POST NO BILLS" http://mcmbednarek.tripod.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver Error - an unexpected internal error has occurred | Excel Discussion (Misc queries) | |||
Excel 2007 Solver Error | Excel Worksheet Functions | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Using the solver in excel 2000 | Excel Discussion (Misc queries) | |||
Where can I download the "solver" add-in for Excel 2000? | Excel Discussion (Misc queries) |