H Harry Bratton Aug 16, 2003 #1 I'm hoping someone can give me the VBA code to open a new workbook in the activewindow. Thanks in advance Harry.
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 Aug 16, 2003 #2 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
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
