Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver automatically in the VBA Reference
I have to automatically (when someones open the Excel)
activate the Solver Box in the VBA reference. Is that possible, does anybody knows how to do that? Thanks Velero |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver automatically in the VBA Reference
Adapt this
Sub Run_Solver() On Error Resume Next With Application.AddIns("Solver Add-In") ..Installed = True ThisWorkbook.VBProject.References.AddFromFile Filename:=.FullName End With 'MsgBox "attempting to use solver. May require a double check" For x = 1 To 7 Stage = "Stage" & x With Worksheets(Stage) ..Activate solverOk ' SolverSolve userFinish:=True SolverFinish keepFinal:=1 ' End With Next x Exit sub wrote in message ... I have to automatically (when someones open the Excel) activate the Solver Box in the VBA reference. Is that possible, does anybody knows how to do that? Thanks Velero |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver formula "Equal to Value of:" cell reference | Excel Discussion (Misc queries) | |||
Multiple Solver uses automatically | Excel Discussion (Misc queries) | |||
Solver reference problem | Excel Programming | |||
VBA code to add a reference to solver | Excel Programming | |||
access the solver reference library | Excel Programming |