Solver in Excel 2007

G

Guest

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
 
T

Tushar Mehta

It appears I am ref'ing .xla and not .xlam. Is there a way to update the
reference?
Click to expand...
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
 
J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Help creating a macro that will run Solver? 3
Solver Macro in Excel 2007 1
Using Solver with Excel 2007 VBA 1
Solver with VBA 1
Excel Solver Programming Error 4
Excel using vba code for solver in Excel 0
Solver in VBA 4
Using Solver add-in across multiple computers 7

Top