VBA to Call Multiple Macros

Originally Posted by Norie

What happens if you move WBMerge to the same workbook as Macro1 and WSMerge?

You should then be able to call both subs like this.

Sub Macro1()

    WBMerge
    WSMerge

End Sub

Initally I wanted to merge the workbooks that are in a different directory to a master file but couldnt get it work across directories, so I ended up placing a dummy book in the same directory as the workbooks to be merged and running a data connection to it. Might have to re visit that plan I think!
lol

Thanks!