Closing / Opening Workbooks

Hi folks,

Happy New Year to all.

I have a workbook containing a macro that asks the user to do a SaveAs of that workbook by popping a SaveAs dialog box up for the user to use. After that's done, is there a way to close the active workbook and go open the saved one, through the (same) macro? Or will the moment the workbook closes cause the macro to also quit? Do I have to open the saved-as version before closing the current one?

Is there another way of achieving this (if the above isn't possible)?

Yes, you need to close the workbook before opening the other one. Or, as you guessed, the macro will quit before it gets to the Open command.

If you want a process to "continue" with the opened workbook, you could use Application.OnTime to call a subroutine.