I would like to open a new workbook in a separate window. I have set up Excel
to do this when you double click a file to open but when doing it
programmatically, it always opens inside the activeworkbook. How can a new
workbook be added in a separate window? Excel 2003/Windows XP.

Dim targetWorkbook As Workbook
Set targetWorkbook = Application.Workbooks.Add