lashings1986
New Member
- Joined
- Jul 25, 2017
- Messages
- 6
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
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