How Do I move a Spreadsheet to a New Instance of Excel

[gambit023]

Is there a way to move an already open spreadsheet to another instance of Excel?

I'm running Excel 2007.


Thanks in advance!

 

[RoryA]

Personally, I'd go with stretching the app though!

 

[Rekd]

The MDI interface on Excel leaves much to be desired.

Is there a way to move an already open spreadsheet to another instance of Excel?

I'm running Excel 2007.


Thanks in advance!

Try something like this:

Sub NewInstance()
    Set objExcel = CreateObject("Excel.Application")
    objExcel.Visible = True
    objExcel.Workbooks.Open ("W:\MyDir\MyFile.xls")
End Sub

You'll want to pull the workbook name ("W:\MyDir\MyFile.xls" in this example) of the current file and close it in the original instance before you open it in the new instance to not be in read only mode.

 

[Rekd]

This should work...

Sub NewInstance()
    Dim sCurFile As String
    sCurFile = ActiveWorkbook.FullName
    ActiveWorkbook.Close
    Set objExcel = CreateObject("Excel.Application")
    objExcel.Visible = True
    objExcel.Workbooks.Open (sCurFile)
End Sub

 

[c_wag03]

This should work...

Sub NewInstance()
    Dim sCurFile As String
    sCurFile = ActiveWorkbook.FullName
    ActiveWorkbook.Close
    Set objExcel = CreateObject("Excel.Application")
    objExcel.Visible = True
    objExcel.Workbooks.Open (sCurFile)
End Sub

I know this is an old thread, but just wanted to say I was having the same frustration of having 2 excel files open in the same instance and wanting to move one to a separate instance without having to manually close and the open the file in a new instance. This suggestion seems to have worked perfectly!