Prevent new workbooks to open in same instance

Hi
I have a workbook that I want to allways be open in its own instance. It must prevent other workbooks to open in the same instance, and if other workbooks already is open, it must open it self in a new instance. Is there a code I can use to do what i want?



Hope I explained my self well enough.

This code will open an excel file in a new instance in read only.

Hope this helps

Please Login or Register  to view this content.

Dim objExcel
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook = objExcel.Workbooks.Open("YOUR FILE PATH HERE.xlsm ", ReadOnly:=True)

Please Login or Register  to view this content.

Hi
I tried the code, but it didn't work. It's a possibillity that I didn't do it right. Exactly where do I put the code? I placed it in "ThisWorkbook".

Originally Posted by brewsi

This code will open an excel file in a new instance in read only.

Hope this helps

Please Login or Register  to view this content.

Dim objExcel
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook = objExcel.Workbooks.Open("YOUR FILE PATH HERE.xlsm ", ReadOnly:=True)

Please Login or Register  to view this content.

Doesn't work...