Open a File in a Separate Instance of Excel from Explorer

Maryz

Board Regular
Joined
Dec 10, 2002
Messages
197
I know that I can open a file in a new instance of Excel using VBA from a source file:

Public appxl As Application
Sub OpenAnotherInstanceXL()
Set appxl = CreateObject("Excel.Application")
With appxl
.Workbooks.Open ThisWorkbook.Path & "\" & "OpenMe.xls"
.Visible = True
End With
End Sub

What I’d like to know is if it is possible to have a file open in a new instance of Excel when selected from Windows Explorer while my source file is open. What I’d like to accomplish is to have my source file always be the only file open in its own instance. Is there any way to accomplish this?
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
Re: Open a File in a Separate Instance of Excel from Explore

Try this: With one Excel file open in Excel, open another Excel, then, with the new Excel highlighted (selected), open the new file. You will now have two Excel programs open, each with its own file.

You can continue to open new Excel programs and new Excel files. Just select the one to work on, and take it from there.
 

Maryz

Board Regular
Joined
Dec 10, 2002
Messages
197
Re: Open a File in a Separate Instance of Excel from Explore

Ralph,

What you are describing is a manual procedure. What I am looking for is an automated procedure using VBA. For example, MyFile.xls is opened on my desktop and I go to open NewFile.xls from Windows Explorer and NewFile.xls is opened in a new different instance of Excel than MyFile.xls. If there were two instances of Excel opened at once, I’d need the second instance to have the focus each time somebody tried to open a file through Explorer.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,484
Messages
5,596,407
Members
414,064
Latest member
Duncthegreat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top