Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 13th 19, 08:46 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2018
Posts: 43
Default 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   Report Post  
Old December 14th 19, 12:30 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,182
Default 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.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #3   Report Post  
Old December 14th 19, 06:23 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2018
Posts: 43
Default Problem loading Solver

On Friday, December 13, 2019 at 6:30:27 PM UTC-6, 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.eternal-september.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   Report Post  
Old December 14th 19, 07:04 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2018
Posts: 43
Default Problem loading Solver

On Friday, December 13, 2019 at 6:30:27 PM UTC-6, 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.eternal-september.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   Report Post  
Old December 14th 19, 11:23 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,182
Default Problem loading Solver

On Friday, December 13, 2019 at 6:30:27 PM UTC-6, 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.eternal-september.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 Add-in is not listed in either but is listed (only
once) in each installed version of Excel Add-ins Manager dialog. Checking it
causes Excel to install this addin on 1st use, but it does not show in the
Registry where other Add-ins 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.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


  #6   Report Post  
Old December 15th 19, 09:54 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 48
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





  #7   Report Post  
Old December 15th 19, 10:46 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2018
Posts: 43
Default Problem loading Solver

On Sunday, December 15, 2019 at 3:54:24 PM UTC-6, 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 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


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   Report Post  
Old December 16th 19, 02:04 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
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


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.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #9   Report Post  
Old December 16th 19, 05:53 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
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
  #10   Report Post  
Old December 16th 19, 11:57 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 48
Default Problem loading Solver


"programmernovice" wrote in message
...
On Sunday, December 15, 2019 at 3:54:24 PM UTC-6, 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 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


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 \Add-in 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 Hkey-Users\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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver model loading problem marineCORVETTEran Excel Discussion (Misc queries) 0 July 17th 08 11:31 PM
Referencing and loading Solver programatically - how? CodeMonkey Excel Programming 11 May 4th 06 05:27 PM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
Add-in loading problem richardreye Excel Programming 0 September 6th 04 03:31 AM
File Loading Problem Jason Hancock Excel Programming 1 June 20th 04 08:53 PM


All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017