Add Workbook with specified name

[Todd Huttenstine]

Hey guys

I am trying to create a workbook called "Ops Reports
Temporary". Its not working. What should it be?

Dim WB As Workbook
Set WB = Workbooks("Ops Reports Temporary").Add


Thanx
Todd Huttenstine

 

[Ron de Bruin]

Try this

Dim WB As Workbook
Set WB = Workbooks.Add
WB.SaveAs "Ops Reports Temporary.xls"

 

[Don Guillett]

try

Sub addnamewb()
Workbooks.Add.SaveAs Filename:="Don.xls"
End Sub