SOLVER COMPILE ERROR : CAN'T FIND PROJECT OR LIBRARY

N

Nina

Hi I am having trouble with Excel 2007 - I created a solver macro (looping)
in excel 2003 and now in Excel 2007 is not working. I have added solver to
the vba reference but now I get a compile error - "Can't find Project or
Library" - well I copied the macro to another module and gave another name
but it still does not work... any help is really appreciated.

Thanks,
 
B

Bob Flanagan

Have you installed SP1 yet for 2007? It solves this error sometimes. You
may need to do a repair of Office after installing to fix what it screws up.
Seriously.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 

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

SOLVER COMPILE ERROR: "CAN'T FIND PROJECT OR LIBRARY" 2003 VS 2007 1
Excel 2007: Creating a macro that will run Solver. 0
Excel 2007: Help creating a macro that will run Solver? 3
Excel 2007: Help creating a macro that will run Solver? 0
Solver - error - Compile Error 0
Solver Compiler issue 2
Solver Error 0
error in solver add-in 0

Top