Ok, here one way to invoke the Solver addin.
VB Code:
Dim oCBmnuTools As Office.CommandBarPopup Dim oCBmnuSolver As Office.CommandBarButton Set oCBmnuTools = Application.CommandBars("Worksheet Menu Bar").Controls("&Tools") Set oCBmnuSolver = oCBmnuTools.Controls("Sol&ver...") oCBmnuSolver.Execute





Reply With Quote