Solver Frustration

[Tkeller]

Hello,

I have been searching the forum here and other places and can not get this to work without giving me the dreaded "complie Error Can't find project or library". I am able to run Solver manually from within excel with no issues. In tolls/reference "solver" is clicked. Yet, I still get this error.

I am running EXCEL 10, if this matters. Here is my code.

Sub Solver()


SolverReset

SolverOk SetCell:=Range("Balance"), _
MaxMinVal:=3, _
ValueOf:=0, _
ByChange:=Range("Amount")
SolverSolve UserFinish:=True

End Sub

 

[shg]

Try this:

In the VBE, Tools > References, untick Solver, then press Browse.

Paste this in the File name box

C:\Program Files\Microsoft Office\OFFICE10\Library\SOLVER<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

Change the file type dropdown to *.xls, *.xla, and pick SOLVER.XLA<o></o>

 

[Tkeller]

Thanks. I don't have that exact same path, but did what you suggested and it is still giving me this error. This is what I did

1) I went into VBE and unchecked solver
2)Then I browsed and changed the file location to:
C:\Program files (x86)\Microsoft Office\Office14\Library\SOLVER
3) I changed the filedrop down to *.xla and selected the file solver.xla

All the above steps worked fine, but when I try to run I stil get this same error. Ugh!

 

[shg]

I understood you were using Excel 10, which is Excel XP (2002).

I don't have Excel 2010 to test.

 

[Tkeller]

Sorry, my mistake. I am using the latest version of Excel. I understand you can not help, and appreciate your suggestios. Perhaps it has something to do with my opreationg system which is windows 7 64 bit?

 

[Tkeller]

I solved my problem. For whatever reasons, if you have a MISSING file in your list of references, if you deselect this, then it miraculously works.