you need to use save as method i.e.
ActiveWorkbook.SaveAs ("Filename")
"chrisnsmith" wrote:
I use the following macro I created with the macro recorder to add a new
workbook
without vb code for emailing. What I need to know is how to give a name to
this workbook after it is created. Help would be appreciated.
Workbooks.Add
Windows("Form 200").Activate
Sheets(Array("Cus Futures", "House Futures", "Cus Calls", "Cus Puts", _
"House Options", "Cus Indexes")).Select
Sheets("Cus Futures").Activate
Sheets(Array("Cus Futures", "House Futures", "Cus Calls", "Cus Puts", _
"House Options", "Cus Indexes")).Copy Befo=Workbooks("Book2").Sheets(1)