New WorkBook in the Active Window

[Harry Bratton]

I'm hoping someone can give me the VBA code to open a new workbook in the
activewindow.
Thanks in advance
Harry.

 

[Bob Phillips]

Harry,

As a small addition to Chip's advice, I tend to create a workbook object
when I add a new workbook, as this gives me a handle to reference the new
workbook with.

Dim oWbTest As Workbook

Set oWbTest = Workbooks.Add