Hi All,
I'm having an issue with calling multiple macros in VBA and was wondering if someone could offer me some insight.
In the code below, Macro1 is supposed to open a workbook in another directory, run the macro (WBMerge)stored in that other workbook (which merges worbooks in that directory then saves and closes that workbook), then another Macro ("WSMerge" which merges worksheets in the current workbook) that is stored in the current workbook.
The first two lines run great, but "WSMerge" wont execute (WSMerge works fine by itself).
Any help would be greatly appreciated, thanks!
Sub Macro1()
Application.Workbooks.Open ("directorypath\workbook1.xlsm")
Application.Run ("workbook1.xlsm'!WBMerge")
WSMerge
End Sub
Bookmarks