How to open Excel in new instance?

[dmadhup]

Hello,

I am using Office 365 and when I open two Excel file then it opens on the same instance. For some reason, I am looking to open in a separate instance.
Anyone has an idea how to achieve it. I appreciate your response.

Thank you!

 

[ZVI]

Nice to know that we could help. Thanks for the responce!

 

[dmadhup]

Whenever I double-click the Excel file, it opens a new workbook and stays open. I wonder it happens on my PC even you have used code: Me.Close False

 

[dmadhup]

I notice that Me.Close only close the read-only workbook not quit. And I can't use me.Quit

So, how can we exit the read-only workbook?

 

[ZVI]

Whenever I double-click the Excel file, it opens a new workbook and stays open. I wonder it happens on my PC even you have used code: Me.Close False

Just check if only this workbook is visible like this:

Private Sub MyOpen()
  Dim oAddIn As AddIn, Wb As Workbook, i As Long
  ' Check if only this workbook is visible
  For Each Wb In Workbooks
    If Wb.Windows(1).Visible Then i = i + 1
    If i > 1 Then Exit For
  Next
  If i = 1 Then
    Call ShowUserForm
    Exit Sub
  End If
 
  ' Change access to read only
  ' ... the previous code ...
 
End Sub

Regards

 

[dmadhup]

I understand the logic.
Thank you very much ZVI

 

[ZVI]

You are welcome!