SaveCopyAs Method of Workbook Object VBA

‘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.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

Why we need SaveCopyAS in Workbook using VBA?

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.

Sub Workbook_SaveCopyAs()
ThisWorkbook.SaveCopyAs ThisWorkbook.Name & "_Ver1"
End Sub

VBA SaveCopyAS Workbook – Instructions

  1. Open an Excel Workbook
  2. Press Alt+F11 to Open VBA Editor
  3. Insert a Module from Insert Menu
  4. Copy the above code for activating a range and Paste in the code window(VBA Editor)
  5. Save the file as macro enabled workbook
  6. Press ‘F5’ to run it or Keep Pressing ‘F8’ to debug the code line by line.
  7. You can find saved workbook in the following location: ThisWorkbook.Name & “_Ver1”.

Leave A Comment

Related pages

microsoft excel chart tutorialexcel template plannerado database connectiondml ddl sqlinterior colorindexconverter excel to csvvba excel match functionhow to do a pivot table in excel 2013excel progress bar vbamacros for beginnersupdate sql database from excelhow to use the lookup function in excel 2010how to enter a macro in excelhow to delete all empty rows in excelhow to learn macros in excelshort cut excelv lookup h lookup pivot tablevba advanced filter criteriamicrosoft excel insert rowexcel vba userform frameexcel merge cells formulavba loop syntaxhow to insert a pivot table in excel 2013sum if condition in excelexcel macro close excelcode in vbaexcel formulas with exampleexcel 2013 merge cellslistbox excelvba macro code examplesvba connect to databasevba excel macroexcel formulas made easyworkbooks open filename vbaaccess vba read text filefile dialog vbastock chart in excelprotect sheet macroexcel vba tabvba databasecopy excel workbookvba count cellsunmerge cell excelhow to calculate difference between dates in excelexcel append stringsms access vba create tablevba excel pastespecialopen and activate workbook vbahow do you password protect an excel spreadsheetadvanced charting in exceldeveloper tab in excelmacro remove duplicatesapplication function vbasort worksheets in excelexcel shortcut to delete rowshortcut key to insert a row in excelvlookup examplesexcel naming a rangesql basic commands with examplesvlookup in microsoft excelexcel construction templateshow to make hlookup in excelsql data manipulation commandstesting template excelprogramming excel vbaclient tracking excel templatepassword vbaremove blank cells in excel formulaexcel shortcuts and formulasexcel vba advanced filter multiple criteriavlookup tutorial excel