View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Adding New Woıkbook with a specific name

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.