Home > VBAUsefulCodes
Use the following Excel VBA code to create a new Excel Workbook and save it in a given path as shown in the below code.
Excel Macro to Create a new Excel workbook file
Use the following Excel VBA code to create a new Excel Workbook and save it in a given path as shown in the below code.
Sub CreateNewExcelWorkbook()
Dim wb As Workbook
Set wb = Workbooks.Add
' now if you want to save this new workbook
' save it by providing the full name of the file
wb.SaveAs "C:\abc\temp.xlsx"
End Sub
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts