View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Problem loading Solver

"programmernovice" wrote in message

I use Solver with Excel 2007. After starting Excel, Solver will not work.
Both boxes for Solver Addins (yes, there are 2) are checked. The only
solution I have found is to uncheck both boxes, close the addins list,
opening it again and check both boxes. After closing, Solver works fine.

I have tried to write VBA scripts to automate this but none have worked. Only
the manual procedure indicated will do the trick.

==========================

Pretty sure you shouldn't have two Solver addins, only solver.xlam; there's
also a helper Solver32.dll. If you've got two ticked what are their
respective filenames.., can't be the same and both loaded.

If the solver addin was unpacked when you installed Office it should be in
the Library folder, a subfolder of Office 2007 in program files. Bundled
addin files in this folder automatically exist in the addins collection, and
with code should be able to un/install it (ie ticked to load on startup)
Dim ad as addin
Set ad = Application.Addins("Solver Add-in")
ad.Installed = True

Might be worth looking in -
HKCU\\Software\Microsoft\Office\12.0\Excel\Options
and and look for any conflicts, two OPEN keys with solver perhaps

Peter T


Is Solver32.dll a COMAddin for the same thing?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion