Solver in Excel 2007
 

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

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

Solver in Excel 2007
 

In article ,
says...
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

In article ,
says...
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

Solver in Excel 2007
 

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
|
|
|