Hi,

Windows7, Excel 2007
The path of the solver file reference is :
C:\Program Files (x86)\Microsoft Office\Office12\Library\SOLVER\SOLVER.XLAM

The file you are looking for is : Solver.xla or solver.xlam, not a .dll file.
In the browser, you have to change the type of file of the list
and then, you add the .xla or .xlam file






"willemeulen" a écrit dans le message de groupe de
discussion : ...

Set up a macro which is using solver but am unable to add the reference.
When browsing I find the *.ddl file for solver but get an error messege
when I want to open the dll file.

"! Cant add a reference to the specified file."

According to the help I am trying to add a library file which can not
be used/read by VB?

Find the file uder program files/ MS office / Office 11 / Add ins /
Library / Solve

Does anybody have any idea why I am unable to add the library?
wko


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: 285
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=168725

Microsoft Office Help