Is there a way to close an active workbook and then to immediately re-open the same workbook via VBA? I tried having two lines of code in a macro to do this, but the macro stops executing after the close command and never gets to the open.
Here's what I have:
ActiveWorkbook.Close savechanges:=False
Workbooks.Open ("C:\Users\perfi\OneDrive\Documents\Bob\VBA PRACTICE\Consolidated Data - Recovery 7.24 - XX.xlsx")
Is there a way to get around this?
Thank you.
Here's what I have:
ActiveWorkbook.Close savechanges:=False
Workbooks.Open ("C:\Users\perfi\OneDrive\Documents\Bob\VBA PRACTICE\Consolidated Data - Recovery 7.24 - XX.xlsx")
Is there a way to get around this?
Thank you.