Adding New Woıkbook with a specific name

[Tolga & Hande]

We want to add a new workbook in the VB but with a
specific name. We know to use "Workbooks.Add" command
but do not know how to specify name. We also can solve
it with save as as soon as we add it. But want to know
if there is a single command to do that.

 

[Ron de Bruin]

Try this

Dim wb As Workbook
Set wb = Workbooks.Add
wb.SaveAs "C:\test.xls"

 

[Jake Marx]

Hi Tolga & Hande,

Saving the workbook is the only way to name it. You can do it in one
statement if you'd like:

Workbooks.Add.SaveAs "C:\test.xls"