Create new workbook problem

[melewie]

Morning all,

I am trying to create a new workbook but I dont want to save it so the workbook name will be book 'x'.

What I need to do is refrence the new workbook something like

Dim NewWB as workbook
 
workbooks.add
 
new workbook = NewWB

Any help would be great.

 

[VoG]

Try

Dim NewWB As Workbook
Set NewWB = Workbooks.Add

 

[melewie]

senior moment there....which is worrying im 24!!