View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stratuser stratuser is offline
external usenet poster
 
Posts: 21
Default Resetting Solver Manually to Fix Solver Bug

I have an application that runs Solver from VBA, or at
least it used to. With our new Excel 2003 SP1 version,
the macro now produces an "unexpected error" when the code
invokes Solver. But I've found that if I manually reset
Solver from the worksheet and then run the macro,
everything works fine. It's seems as if the worksheet is
looking for the Solver files in the wrong place, and
manually resetting Solver from the worksheet links it to
the proper files.

Any ideas? Where are the Solver files supposed to be?