Pete,

Sub test()
Dim wkb As Workbook

Set wkb = Workbooks.Add
MsgBox wkb.FullName
End Sub

Rob


"pete" wrote in message
...
for a newly created workbook, how can I store a reference to the
workbook in a variable ,

thanks

pete