game_federer
New Member
Hi All,
I wanted to create a backup copy before I run the subroutines Ive written for my file.
Ive used the following code.
The problem is it closes the original file and runs the macros created on the backup copy.
Your help would be greatly appreciated.
I wanted to create a backup copy before I run the subroutines Ive written for my file.
Ive used the following code.
Code:
path_new = ActiveWorkbook.Path
ActiveWorkbook.SaveAs Filename:=path_new & "\Backup_Copy"
The problem is it closes the original file and runs the macros created on the backup copy.
Your help would be greatly appreciated.