VBA-Excel: Create a WorkBook at Runtime.

Using VBA (Visual Basic for Applications) , you can create Excel workbook at the runtime by using Add() method.

If you won’t provide any name for the workbook it will be created as BookN, where N will increase automatically, starting from 0, as you call WorkBook.Add() function.

Function FnCreateWorkBook()

         Dim objWorkBook As Workbook

         Set objWorkBook = Workbooks.Add

         objWorkBook.SaveAs Filename:="NewWorkBook.xls"

End Function

.Add() method creates a workbook and return object of the that. Later on you can use that object to save it to specific location or other operations.

Also Read:

1. VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays)
2. VBA-Excel: Delete Blank Rows from Excel Work Sheet
3. Excel-VBA : Open a Excel File using Another Excel File using Browse Option.
4. VBA-Excel: Create worksheets with Names in Specific Format/Pattern.
5. VBA Excel - Cells, Ranges and Offset: Refer to Cells by Using Shortcut Notation