Calling macro from another workbook

Hi,

There is a workbook at C:\RENTS\FINAL ANSWER.xlsm from where couple of macros needs to run.

Those two macros are at C:\RENTS\FINAL.xlsm and S:\RENTS\FINAL.xlsm
Name of first macro at (C:\RENTS\FINAL.xlsm) is MACRO1 and the name of second macro at (S:\RENTS\FINAL.xlsm) is MACRO2

Whats the code that runs those two macros simultaneously?

Any ideas will be well appreciated.
Thank you

Please Login or Register  to view this content.

Hi, AlphaFrog thanks for the code, but after running MACRO1 it just stops there instead of running MACRO2.
pls guide
thanks

this is the code i have so far:

PHP Code: 

Private Sub CommandButton1_Click()

Application.Run "'C:\RENTS\FINAL.xlsm'!MACRO1"
Application.Run "'S:\RENTS\FINAL.xlsm'!MACRO2"
 
ActiveWorkbook.Save
ActiveWorkbook.Close

End Sub

Private Sub CommandButton2_Click()


Application.Run "'C:\RENTS\FINAL.xlsm'!MACRO1"
Application.Run "'S:\RENTS\FINAL.xlsm'!MACRO2"
 
ActiveWorkbook.Save

Application.DisplayAlerts = False
    Application.Quit
     '//shut down the computer
    Shell "shutdown -s -t 02", vbHide


End Sub