Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #111239
| From | "Peter T" <askmy@email.com> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Problem loading Solver |
| Date | 2019-12-15 21:54 +0000 |
| Organization | A noiseless patient Spider |
| Message-ID | <qt6a2a$h0u$1@dont-email.me> (permalink) |
| References | <1cf19bb7-66eb-4457-8d57-7be4ec254829@googlegroups.com> |
"programmernovice" <ivandenisovich826@gmail.com> 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
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Problem loading Solver programmernovice <ivandenisovich826@gmail.com> - 2019-12-13 12:46 -0800
Re: Problem loading Solver GS <gs@v.invalid> - 2019-12-13 19:30 -0500
Re: Problem loading Solver programmernovice <ivandenisovich826@gmail.com> - 2019-12-14 10:23 -0800
Re: Problem loading Solver programmernovice <ivandenisovich826@gmail.com> - 2019-12-14 11:04 -0800
Re: Problem loading Solver GS <gs@v.invalid> - 2019-12-14 18:23 -0500
Re: Problem loading Solver "Peter T" <askmy@email.com> - 2019-12-15 21:54 +0000
Re: Problem loading Solver programmernovice <ivandenisovich826@gmail.com> - 2019-12-15 14:46 -0800
Re: Problem loading Solver "Peter T" <askmy@email.com> - 2019-12-16 11:57 +0000
Re: Problem loading Solver GS <gs@v.invalid> - 2019-12-15 21:04 -0500
Re: Problem loading Solver "Peter T" <askmy@email.com> - 2019-12-16 12:04 +0000
Re: Problem loading Solver GS <gs@v.invalid> - 2019-12-16 07:08 -0500
Re: Problem loading Solver "Peter T" <askmy@email.com> - 2019-12-16 18:04 +0000
Re: Problem loading Solver GS <gs@v.invalid> - 2019-12-16 13:15 -0500
Re: Problem loading Solver programmernovice <ivandenisovich826@gmail.com> - 2019-12-16 11:21 -0800
Re: Problem loading Solver programmernovice <ivandenisovich826@gmail.com> - 2019-12-16 11:31 -0800
Re: Problem loading Solver Claus Busch <claus_busch@t-online.de> - 2019-12-16 20:42 +0100
Re: Problem loading Solver GS <gs@v.invalid> - 2019-12-16 14:44 -0500
Re: Problem loading Solver "Peter T" <askmy@email.com> - 2019-12-16 20:34 +0000
Re: Problem loading Solver programmernovice <ivandenisovich826@gmail.com> - 2019-12-16 14:24 -0800
Re: Problem loading Solver "Peter T" <askmy@email.com> - 2019-12-17 14:01 +0000
Re: Problem loading Solver programmernovice <ivandenisovich826@gmail.com> - 2019-12-17 08:04 -0800
Re: Problem loading Solver "Peter T" <askmy@email.com> - 2019-12-17 16:12 +0000
Re: Problem loading Solver "Peter T" <askmy@email.com> - 2019-12-17 16:14 +0000
Re: Problem loading Solver programmernovice <ivandenisovich826@gmail.com> - 2019-12-17 09:43 -0800
Re: Problem loading Solver "Peter T" <askmy@email.com> - 2019-12-17 18:52 +0000
Re: Problem loading Solver programmernovice <ivandenisovich826@gmail.com> - 2019-12-17 13:06 -0800
Re: Problem loading Solver GS <gs@v.invalid> - 2019-12-18 01:17 -0500
Re: Problem loading Solver GS <gs@v.invalid> - 2019-12-16 00:53 -0500
Re: Problem loading Solver "Peter T" <askmy@email.com> - 2019-12-16 11:59 +0000
Re: Problem loading Solver GS <gs@v.invalid> - 2019-12-16 07:06 -0500
csiph-web