Home 
Search 
Today's Posts 
#1




Problem loading Solver
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. Any help appreciated. 
#2




Problem loading Solver
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. Any help appreciated. Have you tried Repairing your Office?  Garry Free usenet access at http://www.eternalseptember.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion 
#3




Problem loading Solver
On Friday, December 13, 2019 at 6:30:27 PM UTC6, GS wrote:
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. Any help appreciated. Have you tried Repairing your Office?  Garry Free usenet access at http://www.eternalseptember.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion Thanks Garry. Sorry about my ignorance, but how do you do that? 
#4




Problem loading Solver
On Friday, December 13, 2019 at 6:30:27 PM UTC6, GS wrote:
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. Any help appreciated. Have you tried Repairing your Office?  Garry Free usenet access at http://www.eternalseptember.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion Hi Garry. I have figured out how to do Repair. Unfortuntely it did not help. Any other ideas? Your help is greatly appreciated. 
#5




Problem loading Solver
On Friday, December 13, 2019 at 6:30:27 PM UTC6, GS wrote:
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. Any help appreciated. Have you tried Repairing your Office?  Garry Free usenet access at http://www.eternalseptember.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion Hi Garry. I have figured out how to do Repair. Unfortuntely it did not help. Any other ideas? Your help is greatly appreciated. Addins are registered in either the HKey_Current_User or the HKey_Local_Machine Registry locations. Solver Addin is not listed in either but is listed (only once) in each installed version of Excel Addins Manager dialog. Checking it causes Excel to install this addin on 1st use, but it does not show in the Registry where other Addins or COMAddins show. Once installed, it's available to all installed versions of Excel, for all users. That suggests it registers under HKey_Current_Root;  good luck finding where!  Garry Free usenet access at http://www.eternalseptember.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion 
#6




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 Addin") 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 
#7




Problem loading Solver
On Sunday, December 15, 2019 at 3:54:24 PM UTC6, Peter T wrote:
"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 Addin") 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 Thanks Peter. I appear to have a conflict between the XLA and XLAM versions of the Solver file. For many years I used XLA with E 2003. Now after opening E 2007, I get messages indicating it cannot find XLA. Per your suggestion,I did find XLA listed (as well as XLAM)and I removed Solver.XLA from the registry. In the Addins file under Users\...\Roaming\Microsoft\Addins I located Solver.XLAM. After all this, Excel is still looking for Solver.XLA. Can you please suggest steps to permanently "divorce" Excel 2007 from Solver.XLA. Thank you very much for your help, this is a really nagging problem! 
#8




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 Addin") 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 That's really good info to know, thanks! (Geez, you'd think I'd know this tidbit already;  it just might help with my Addins Manager app!)  Garry Free usenet access at http://www.eternalseptember.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion 
#9




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 Addin") 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.eternalseptember.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion 
#10




Problem loading Solver
"programmernovice" wrote in message ... On Sunday, December 15, 2019 at 3:54:24 PM UTC6, Peter T wrote: "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 Addin") 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 Thanks Peter. I appear to have a conflict between the XLA and XLAM versions of the Solver file. For many years I used XLA with E 2003. Now after opening E 2007, I get messages indicating it cannot find XLA. Per your suggestion,I did find XLA listed (as well as XLAM)and I removed Solver.XLA from the registry. In the Addins file under Users\...\Roaming\Microsoft\Addins I located Solver.XLAM. After all this, Excel is still looking for Solver.XLA. Can you please suggest steps to permanently "divorce" Excel 2007 from Solver.XLA. ==================================== AFAIK bundled addins like solver should not be in Roaming\Microsoft\Addins, that's the default location for your own addins ?application.UserLibraryPath Bundled addins should be in the 'Library' folder I mentioned ?application.LibraryPath If you deleted any reference to the solver.xla in the registry I don't know why Excel is still looking for it, do you get some sort message about that when Excel loads? I would uninstall Solver, move all solver files say to desktop. Look at Options and make sure Solver is not listed, and if you deleted any OPEN# entries you 'decremented' any later OPEN# so you've got OPEN, OPEN1,2, 3 etc Look in \Addin Manager in the same path as Options, that's where uninstalled addins not in one of the library paths (see above) get listed. Maybe search the registry for solver in case mirrored in a HkeyUsers\S type listing If you can get rid of all trace try moving solver.xlam to the app.LibraryPath Or might be better to extract with the Office setup in control panel  programs, don't recall exactly but you should be able to find it. Peter T 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Solver model loading problem  Excel Discussion (Misc queries)  
Referencing and loading Solver programatically  how?  Excel Programming  
Interesting Solver problem (Solver encounters an error)  Excel Discussion (Misc queries)  
Addin loading problem  Excel Programming  
File Loading Problem  Excel Programming 