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
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.![]()
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"
How do I make the original macro continue after the Unknown Workbook.xls closes and I have my original workbook still open?![]()
Application.Run "'Active Workbook.xls'!Macro 2" Application.Run "'Active Workbook.xls'!Macro 3"
Bookmarks