Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #111244
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Problem loading Solver |
| Date | 2019-12-16 00:53 -0500 |
| Organization | A noiseless patient Spider |
| Message-ID | <qt765h$imo$1@dont-email.me> (permalink) |
| References | <1cf19bb7-66eb-4457-8d57-7be4ec254829@googlegroups.com> <qt6a2a$h0u$1@dont-email.me> |
> "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
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
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