New WorkBook in the Active Window

H

Harry Bratton

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

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
 
Top