Solver in Excel 2007

[datawired]

I have upgraded to excel 2007 and my solver macro fails on SolverOk. I have
installed solver add-in and it is visible as solver.xlam (pass protected) in
the macro editor. Macro security is not an issue; Basic macros work. I have
added trusted paths and trust all macros.

The error is "Compile error: Can't find project or library."

Anybody run across this yet? Thx...Datawired

 

[datawired]

It appears I am ref'ing .xla and not .xlam. Is there a way to update the
reference?

 

[Tushar Mehta]

It appears I am ref'ing .xla and not .xlam. Is there a way to update the
reference?

Unless I am missing something, the reference should be in your workbook and
it would be up to you to use the VBE and change it.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jim Rech]

So the right Solver version is not appearing in the References list? I
suppose you could rerun the Office installer and make sure you selected
Solver. Or you could futz with the registry. When I select Solver to load
in Excel Options, Add-ins I then see the path to Solver under
HKCU\Software\Microsoft\Office\12.0\Excel\Options at the OPEN key. If
your's points to the wrong version your might point it to the right one
(assuming it's installed).

--
Jim
| It appears I am ref'ing .xla and not .xlam. Is there a way to update the
| reference?
|
| "Jim Rech" wrote:
|
| > Seems okay in my Excel 2007. I'm not a Solver user but I set a
reference to
| > Solver and ran a Solver.SolverOK macro with no errors. Attached is a
shot
| > of Solver's references FWIW.
| >
| > --
| > Jim
| > | > |I have upgraded to excel 2007 and my solver macro fails on SolverOk. I
| > have
| > | installed solver add-in and it is visible as solver.xlam (pass
protected)
| > in
| > | the macro editor. Macro security is not an issue; Basic macros work.
I
| > have
| > | added trusted paths and trust all macros.
| > |
| > | The error is "Compile error: Can't find project or library."
| > |
| > | Anybody run across this yet? Thx...Datawired
| >
| >
| >