Add Workbook As Seperate Window

G

George Lee

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
 
J

JLGWhiz

If you give the TargetWorkbook a name and then save it, it should then be a
separate window from the workbook that was active when the new one was
created. Otherwise, I would think maybe opening a secon instance of Excel
might be what you are after.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro that opens a separate workbook to a specified worksheet whenthe active workbook is right mouse 8
open workbook in new window using VBA 2
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Save As and new workbook new name used in existing code 8
Copying cells and formula from closed workbook to all sheets in open workbook 0
Copy from one workbook to another failing 8
Variable refers to a workbook 2
Help in connecting to MS Access 1

Top