Running a list of Macros from a Macro

[Tuckejam]

I have a Macro that Pulls the 9 digit values from a worksheet and pastes it into a column on the same sheet.

I have a total of 38 sheets and a seperate macro for each. This works fine as sometimes i want to run only the macro for that sheet.

however sometmes I also want to run all of the macros for all of the sheets.

to do this I have just recorded a macro of me running each macro.

and i get this code

Sub Pull_All_Sheets()
'
' Pull_All_Sheets Macro
'
'
    Application.Run "'Store Name.xlsm'!Module2.Bamboo"
    Application.Run "'Store Name.xlsm'!Module2.Borders"
    Application.Run "'Store Name.xlsm'!Module2.Engineered"
    Application.Run "'Store Name.xlsm'!Module2.Laminate"
End Sub

the problem is that this contains the workbook name and i would like to be able to Copy this macro into other workbooks to do the same thing.

Any help is always apreciated

 

[NeonRedSharpie]

You're thinking too hard.

Sub runTheMacro

    Call Module2.Bamboo
    Call Module2.Borders
    Call Module2.Engineered
    Call Module2.Laminate

End Sub

I don't even know if you need the "Module2" part.