![chandoo excel vba examples chandoo excel vba examples](https://cdn.slidesharecdn.com/ss_thumbnails/vbaclasses-intro-wide-110501014145-phpapp01-thumbnail-4.jpg)
Step 2: Define a new sub-procedure which can store a macro. Step 1: Add a new module under Visual Basic Editor (VBE). Examples to Save Excel File using VBA Save As Functionīelow are the different examples to save excel file using VBA Save As function. Like Workbook is the expression against which SaveAs can be used. “Expression” at the start of the syntax is nothing but an expression against which this function can be used. However, it is true that these are the arguments that make VBA SaveAs more flexible function to use. Hush! Lots of arguments right? But what if I tell you, all these arguments are optional and can be skipped while using VBA SAVE AS function. Local – Checks if the workbook is saved with the laws of Excel (local language) or with VBA laws (US – English).AddToMru – Checks if the workbook is added under recently used file or not.
![chandoo excel vba examples chandoo excel vba examples](https://andypope.info/ngs/ng67d.png)
![chandoo excel vba examples chandoo excel vba examples](https://www.automateexcel.com/excel/wp-content/uploads/2018/09/automacro-vba-code-generator-main.png)
ConflictResolution – Recognizes the conflicts that pop-up when the workbook is shared and is used by more than one user.AccessMode – Recognizes the access mode for the workbook.CreateBackup – Determines whether a backup file for the workbook is created or not.ReadOnlyRecommended – Recognizes whether the workbook is saved in Read-Only format or not.