Save Copy Of Workbook & Keep Both Open (Original and copy)

[Tapyr]

Hello,

I am using this macro code for creating copy of my Excel file. I would like to update this code and keep both files opened (original and also new copy), because I need to make some changes in newly copied file and after that save it again.

Could you pls help me write down Action 1. & 3. in following code?

Sub Create_CTRY_file()
    Dim newFile As String, fName As String, Path As String
    
    'define destination folder
    Path = "C:\$user\CB_Data\"
    
    'check if directory exists and create if not
    If Dir(Path, vbDirectory) = "" Then
        MkDir Path
        End If
    
    'define new name
    fName = Range("CTRY").Value & "_CB_data" & "_" & Range("Accounting_year").Value & "_" & Range("Accounting_month").Value
    ActiveWorkbook.SaveCopyAs fileName:=Path & fName & ".xlsx" ', FileFormat:=52
    
    
'WHAT I NEED:
'1, OPEN COPIED FILE
'2, do some stuff in opened copied file
'3, SAVE COPIED FILE AGAIN AND CLOSE IT
    
    
End Sub