Hi. Ok. Just another wild guess... Does your workbook name have any
spaces in it?
There are a few things that won't work with Solver if the workbook name has
a space in it. Also, make sure the workbook is in A1 notation, and not R1C1
notation.
Again...just wild guesses. What version of Excel are you using?

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"CodeMonkey" wrote in message
ups.com...
Dana
thanks for the response. However the code is actually executing within
the excel workbook itself, rather than the Vb6 application. The vb6
application is just opening the workbook and then telling the macro to
execute.

In fact, if I take the excel workbook itself and forget about the vb6
application and then move it to a machine where the solver.xla is in a
different location thus breaking the link to the reference, I find that
I must run my SolverInstall macro (originally from one of your postings
btw!), then save the workbook, close it and reopen it in order for the
reference to be restored. Just running SolverInstall and then trying to
invoke or even AutoOpen Solver will *not* work (project/library not
found error) until the workbook has been saved and reopened.

For now I am stuck with my work-around, but thanks for replying.

Cheers
Andrew