View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
datawired datawired is offline
external usenet poster
 
Posts: 2
Default 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