Vba Save Workbook Without Macros. This saves the current workbook as a non-Macro enabled workbook, but then I obviously cannot run the rest of the macros that I need. In addition to providing some examples of VBA code that you can use to save workbooks , I explain the basics.
The VBA Save As command saves an Excel file as a new file, similar to clicking the Save As icon or using the Save As Shortcut (Alt > F > A). It will save precious time too. How to save an Excel workbook using VBA.
Choose "Excel macro-enabled workbook" from the "Save as type" drop-down list and click the Save button.
SaveAs FileName:=Name, FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False.
This is used when you want to rename your workbook using excel VBA macro. Press Alt + Q to close the Editor window and I have worked it up but now need to delete the data and save it as a template. Here, we used the save as command of Excel using VBA.