‘SaveCopyAs’ method of workbook object is used to saves a copy of the workbook as a file but does not modify or change the open workbook. Please find the more information about SaveCopyAs Workbook method.
Sometimes we may want to save the workbook with changes and we don’t want to modify the opened workbook. So only we need to use ‘SaveCopyAs’ method of workbook object.
VBA SaveCopyAS Workbook – Syntax
Here is the example syntax to saves a copy of Workbook using VBA.
Workbooks(“Your Workbook Name”).SaveCopyAs(
Where Filename: It is an Optional parameter. It will specifies the workbook name to save the copy. But to avoid problems always better to declare the filename. Because if it uses the current file name to save the file in the current folder since the workbook might be open.
VBA SaveCopyAS Workbook:Example 1
Please find the below example, It will show you saveCopyas workbook method.
ThisWorkbook.SaveCopyAs ThisWorkbook.Name & "_Ver1"
VBA SaveCopyAS Workbook – Instructions
Open an Excel Workbook
Press Alt+F11 to Open VBA Editor
Insert a Module from Insert Menu
Copy the above code for activating a range and Paste in the code window(VBA Editor)
Save the file as macro enabled workbook
Press ‘F5’ to run it or Keep Pressing ‘F8’ to debug the code line by line.
You can find saved workbook in the following location: ThisWorkbook.Name & “_Ver1”.