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

vba basic tutorialpivot table basicsvba access database connection exampleoutlook attachment vbaunhide excel 2010macro creation in excelhow to calculate trend analysis in excelprotect excel sheet with passwordmacro codes for excelwith selection vbadeduplicate excelexcel transfer data between worksheetsadodb connection stringlearn vba from scratchhow do you unshare a workbookbasics of excel macrosworksheet vba exceldata dashboard templateuseful vbs scriptssheets excel vbaexcel create vbaddl dml tclexcel macro paste valuesexamples of hyperlinksspotfire dashboard examplesvba sample codeexcel vba averagemicrosoft office project management templateexcel 2007 developer ribbonexcel what if statementsexcel 2013 average functioncountif vba excelcheckbox in vbavbexclamationvba in excel 2007 tutorialworkbooks open in vbavba left functionhow to change excel columns to rowsactivecell endhow to protect excel workbookexcel sort macromacro to combine worksheetsremove duplicates excelexcel formulas for namesopen pdf vbavba listbox columnsvba with accessreturn vbacase in vbamsofiledialogfilepicker vbahow to delete multiple cells in excelmessage box vbaexcel macro delete rowexcel vba & operatormicrosoft graphs and charts templatesmerge column in excelexcel for loopsrun excel macro from accessvba macros excelhow to record a macro in excelhow to remove hyperlink in excel 2007message box excel vbacut and paste worksheetiferror functionoptimisation excelexcel vba status barremove duplicate rows excelusing macros in excelcreateobject scripting filesystemobject vbaspreadsheet control vbahow to unlock an excel spreadsheet for editingexcel function sumifdml commands in sql servervba class methodsunhide row 1 in excel