Run/Call module in multiple Workbooks.

[lashings1986]

I am trying to run a macro in a workbook that opens other workbooks in a file and runs all the vba in Module2 of each specific workbook.

Module2 is different in each of the workbooks

This is the code i am using. It runs through each of the workbooks perfectly I just need it to run the Module2 vba from each workbook. Tried using call function also but doesn't seem to work.

it is the line in bold

Any help would be great.

Sub BatchProcessing()
myPath = "C:\Users\bloomberg\Desktop\updated Morning update models VBA TESTS v2"
MyTemplate = "*.xls*" ' Set the template.
MyName = Dir(myPath & MyTemplate) 'Retrieve the first file
Do While MyName <> ""
Workbooks.Open myPath & MyName
Application.run (module2.updateflagship)
Workbooks(MyName).Close 'close
MyName = Dir 'Get next file
Loop
End Sub



Thanks

 

[lashings1986]

no luck but thanks for your help.