Minitab closes automatically with Excel macros

Question

I want to run the macros to perform capability on the excel file stored separately. I created a minitab macro file and saved it in.MAC format. When I run the excel macro code to open the minitab code, it runs the mac code and closes automatically

    Sub GetModel()

    Dim MtbApp As Object

    ActiveWindow.WindowState = xlMinimized
    Set MtbApp = CreateObject("Mtb.Application")
    

    
    MtbApp.Open "C:\Users\gvadivel\Desktop\Gowtham\Project_3_Capability Study\minitabfile\Minitab.MPJ"
           
    MtbApp.ActiveProject.ExecuteCommand "%test2"


    End Sub

score 0 · Answer 1 · answered May 14 '21 at 05:46

0

Sub GetModel()

Dim MtbApp As Object

ActiveWindow.WindowState = xlMinimized
Set MtbApp = CreateObject("Mtb.Application")



MtbApp.Open "C:\Users\gvadivel\Desktop\Gowtham\Project_3_Capability Study\minitabfile\Minitab.MPJ"

Set mtbUI = MtbApp.UserInterface
    mtbUI.Visible = True
    mtbUI.Interactive = True
    mtbUI.UserControl = True
    mtbUI.DisplayAlerts = True

MtbApp.ActiveProject.ExecuteCommand "%test2"

End Sub

answered May 14 '21 at 05:46

JONSON CHEN

1

If you add a bit of explanatory text it will make this answer more useful to others – WurmD May 15 '21 at 09:44

Minitab closes automatically with Excel macros

1 Answers1