Add Workbook with specified name
 

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

Add Workbook with specified name
 

Try this

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Todd Huttenstine" wrote in message ...
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

Add Workbook with specified name
 

try

Sub addnamewb()
Workbooks.Add.SaveAs Filename:="Don.xls"
End Sub
--
Don Guillett
SalesAid Software

"Todd Huttenstine" wrote in message
...
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