Recording a macro (interating with another application) using VB

Hi Lone,

Thank you for the forum question.

You can use the macro recorder to do what you want. Record you are using the solver to solve what you want the solver to solve. The Solver will not be exposed to the user because you will need to close the solver to stop the macro recorder.

If you have the command button in a private module for a userform just type CALL + the name of the recorded macro in the on_click event.

You will need to refer the solver library. Please have a look at this link:
http://msdn.microsoft.com/en-us/library/office/ff839427 (v=office.15).aspx

Note
The Solver add-in is not enabled by default. Before you can use this function, you must have the Solver add-in enabled and installed. For information about how to do that, see Using the Solver VBA Functions. After the Solver add-in is installed, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select Solver under Available References. If Solver does not appear under Available References, click Browse, and then open Solver.xlam in the \Program Files\Microsoft Office\Office14\Library\SOLVER subfolder.

Question 2:

You are defining where you want the output from the solver in the solver dialog box, so when you click the command button the solver will call the macro where the output is defined.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector