The workbook doesn't get a full name until it is saved.

You could always create a workbook object when you save it

Set oWB = Workbooks.Add

and use that object after that.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Chris Rees" wrote in message
...
Is there anyway to use a workbook name in code without using
application.getsaveasfilename or getopenfilename? As I am trying to create
multiple workbooks from a master workbook and would prefer not to have to
save the workbook every time.