Running Two Macros

[dineshsilicon]

Hi Friends,

I want to create a Excel file which contains a button "RUN", when i click it, it should open the EXCEL x.xls and then it should execute two macros and atlast save the x.xls file and close it.


Can any one please help me to create a script for the above needs.

Thank you,

[Mordred]

Hi dineshsilicon, make your button and add a revised version (your procedures that you are wanting to call) to suit your needs.

Private Sub CommandButton1_Click()

    Dim MyDir As String
    Dim strPath As String
    MyDir = ActiveWorkbook.Path
    strPath = MyDir & "\x.xls"
    Workbooks.Open Filename:=strPath
    Call MacrosName1
    Call MacrosName2
    
End Sub