Re: starting Solver with VBA

Hi.

Sub Solver_Show()
SOLVER.Main
End Sub

--
HTH :>)
Dana DeLouis
Windows XP & Office 2007


"Smallweed" <Smallweed@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8F3B0531-DA08-46A6-A3B9-2177AA51BD1F@xxxxxxxxxxxxxxxx
That works if I actually do some solving with Solver but it doesn't record
code just to display the dialog box - which is all I want it to do.

"merjet" wrote:

Turn on the macro recorder (Tools menu), use Solver manually, turn off
the recorder. The code will be in the VB Editor. Check Solver using
the menu Tools | References in the VB Editor.

Hth,
Merjet





.

Relevant Pages

  • Re: Command line interface and Windows form in same program
    ... I've written a program which has both a command line interface ... and Windows form interface, ... TheProgram.exe) it should display the Windows form only. ... Application' and Startup object is 'Sub Main'. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Wie kann ich im Excel zwei Zellen gleichsetzen?
    ... Makro / VB Editor ... Mappe Du damit beeinflußt. ... Und prompt hast Du schon den Rahmen für Deinen Code sofern es Sub ... >> End If ...
    (microsoft.public.de.excel)
  • RE: Word as Editor with Legault Code
    ... but I would like to use Microsoft Word as my email editor. ... > Private Sub Application_Startup ... > Set objInspectors = Application.Inspectors ... > Private Sub objInspectors_NewInspector(ByVal Inspector As Inspector) ...
    (microsoft.public.outlook.program_vba)
  • Re: Need Help writing Print Macro
    ... menu and works on the active sheet but skips code for all but a specific ... Press Alt/F11 to open the VBA editor. ... Copy the macro into the editor. ... Private Sub Workbook_BeforePrint ...
    (microsoft.public.excel.programming)
  • Re: Option group criteria
    ... When you're in the VB editor, ... Go down the big list to DoCmd. ... Also, when you are typing the call, the VB editor will show a popup ... Private Sub CloseSave_Click ...
    (microsoft.public.access.forms)