Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB solver
AFAIK, it would be illegal for you to distribute the solver files
yourself. If the recipient has the product installed, the code below should work. It has been tested *very* lightly. It also assumes the necessary security permissions are available. Obviously, it would benefit from additional code to respond gracefully to the absence of Solver. Sub testSolverRef() On Error Resume Next ThisWorkbook.VBProject.References.Remove _ ThisWorkbook.VBProject.References("Solver") ThisWorkbook.VBProject.References.AddFromFile _ Application.AddIns("Solver Add-in").FullName On Error GoTo 0 End Sub -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... What can be done to make a VB solver invoked routine work across versions of Excel? Currently the VB code that I write in an Excel 2000 app will not fly when I open the sheet in Excel 2002 nor will a 2002 app fly when brought over to a 2000 excel installation (the VB code however is the same). I realize that the solver file and probably the solver.dll being used by these 2 versions is different, but how can I get around this without distributing a solver.xla and solver.dll file to force into some other user's machine with every app. I send? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to know how to use the solver | Excel Worksheet Functions | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
"solver" | Excel Discussion (Misc queries) | |||
Can solver do this? | Excel Worksheet Functions | |||
Resetting Solver Manually to Fix Solver Bug | Excel Programming |