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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.