Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Overwriting an Existing Workbook

Sub add()      Set myWorkbook1 = Workbooks.Add      Application.DisplayAlerts = False      myWorkbook1.SaveAs Filename:="C:\Data\SalesData1.xlsx"      Application.DisplayAlerts = True End Sub