» Add and Save new Workbook using VBA in Microsoft Excel
CATEGORY - Files, Workbook, and Worksheets in VBA
VERSION - All Microsoft Excel Versions
Place the code below into the standard moduleSub AddSaveAsNewWorkbook() Dim Wk As Workbook Set Wk = Workbooks.Add Application.DisplayAlerts = False Wk.SaveAs Filename:="C:/MyData/SalesData.xls" End Sub
Book Store:
No comments have been submitted.
