When you add a wb, it is automatically the active one:
<font face=Tahoma><SPAN style="color:#00007F">Sub</SPAN> Foo()
Workbooks.Add
With ActiveWorkbook
MsgBox "This is the new one"
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>
So you can refer to it with ActiveWorkbook.
HTH,
Smitty