I have this code that runs the through the first 4 lines. It then stops as I describe below.
For Privacy concerns I am using generic names for workbooks
Sub EVERYWEEKLY()
'
' EVERYWEEKLY Macro
'
'
Application.Run "'Active Workbook.xls'!SEAFOOD"
ChDir "W:\Master Books\Unknown"
Workbooks.Open Filename:="W:\Master Books\Unknown\Unknown Workbook.xls"
Application.Run "'Macro1.xls'!UPDATE"
At this point, Unknown Workbook.xls closes but the original workbook is still open and the following Macro need to run. But the whole Macro stops at this point.
Application.Run "'Active Workbook.xls'!Macro 2"
Application.Run "'Active Workbook.xls'!Macro 3"
How do I make the original macro continue after the Unknown Workbook.xls closes and I have my original workbook still open?
Bookmarks