PDA

View Full Version : solver add in



willemeulen
01-06-2010, 11:31 PM
Found some info to use macro which uses solver add in, when in the VBA editor page under tools, refrences the solver library is not to be found, when I browse and find the solver.dll file it gives me an error telling me the excel is unable to add the library?

Does anybody know what is the problem?:dunno

W

Marcster
01-07-2010, 12:16 PM
Has the Solver add-in been added?.

In the main excel window. Menu bar,
Tools > Add ins...
Then tick:
Solver Add-in (or browse to the solver.xla file)

Then in the VBA Editor goto References and try searching again.

willemeulen
01-07-2010, 10:40 PM
yes the solver was added in, the library does not show under the refference list. 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 / Solver