In the first of two workbooks ("OpeningWkb"), I have code in the Workbook.Open procedure that opens a second workbook ("OpenedWkb").
The second workbook also has a Workbook.Open procedure that closes the initial wkb and then resumes with other code.
The problem is that in the second workbook, no code runs after the code line that closes the initial wkb.
Is there a trick to make this code run to completion?
The example is in the attached workbooks. You'll need to alter the paths to where you've saved the workbooks on your computer (the OpeningWkb file will draw an error the first time you open it).
I've simplified the code as much as possible in the attached workbooks. The ultimate purpose is in updating a file with a new file downloaded from the internet (after transferring info from the initial file, the downloaded file will kill the initial file and then SaveAs into the initial files location).