Solver in Excel 2007
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
|