Try this
Dim wb As Workbook
Set wb = Workbooks.Add
wb.SaveAs "C:\test.xls"
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"Tolga & Hande" wrote in message ...
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.