How-To Run Multiple Macro's One After The Other

[GreenWizard]

I have 4 macro's. The first macro format's data. The second macro saves the .xlsx with a unique name. The third macro merges data from other excel files. And the fourth macro saves the merged data as another .xlsx.

Is there any way to run all the macro's at once and in order? If I group all the code together I have issues, because excel tries to save things before data can be merged or formatted.

Much Appreciated!!!!

 

[JoeMo]

You could use a 'master' macro which launches the other 4 in order. You will need to include the correct macro names.

Sub RunFour()
'change macro names to suit
Call Macro1
Call Macro2
Call Macro3
Call Macro4
End Sub

 

[MARK858]

If they are regular subs and not Workbook or Worksheet subs then create another macro and call the other macro's i.e. if you had macro's called Mac1 and Mac2 then you would do something like

Sub NewMac()
Call Mac1
Call Mac2
End Sub

or even

Sub NewMac()
Mac1
Mac2
End Sub

 

[GreenWizard]

Fantastic!! Works perfectly!!

Thank you so much!!!

 

[byvtary]

Is this still possible? I am desperately trying to get subs to run in a particular order and it does not.

Sub PriceRefresh_Master()
    PriceRefresh__1_ClearC12
    PriceRefresh_1a_PHP
    PriceRefresh_1b_XRP
    PriceRefresh_1c_XLM
    PriceRefresh_1d_BTC
    PriceRefresh__1_CopyC13_PasteC12
End Sub

I don't know if I'm using a regular sub or workbook or worksheet subs.

 

[byvtary]

Is this still possible? I am desperately trying to get subs to run in a particular order and it does not.

Sub PriceRefresh_Master()
    PriceRefresh__1_ClearC12
    PriceRefresh_1a_PHP
    PriceRefresh_1b_XRP
    PriceRefresh_1c_XLM
    PriceRefresh_1d_BTC
    PriceRefresh__1_CopyC13_PasteC12
End Sub

I don't know if I'm using a regular sub or workbook or worksheet subs.

The very last sub (PriceRefresh__1_CopyC13_PasteC12) takes the values a formula calculates in cell C13 and pastes the values in C12, the issue is that it does not wait for the other subs to complete therefore the values that are pasted into cell C12 are incorrect.

 

[kerm007]

can we run the 2 macro from a button press ?
with this :
Sub NewMac()
Call Mac1
Call Mac2
End Sub

Thanks