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
"datawired" wrote in message
...
| 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
| "datawired" wrote in message
| ...
| |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
|
|
|