Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Location
    Minneapolis, Minnesota, USA
    Posts
    16
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Opening workbooks in seperate instances of Excel

    I frequently have a need to have several workbooks open at the same time but would prefer to have them in seperate windows so that I can keep one or more off to the side for reference while I work on another on the other monitor.

    Is there a way to set up a right click choice on an explorer screen to give this as an option.

    My current method of doing this is to open a second copy of excel from the start menu, then drag a workbook from the directory onto it. In addition to taking a few extra steps, it also leaves a copy of book 1 open for me to shut down.

    Bill

  2. #2
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Tennessee,USA
    Posts
    161
    Thanks
    24
    Thanked 17 Times in 15 Posts
    Not sure if this will help, but anyway, here is a couple ways to open 2nd instance.
    1) Double click the shortcut X times to open X BLANK Excel windows.
    4 quick clicks will give you 2 instances, 6 quick clicks will give 3 instances, etc.
    2) hold down Shift while clicking the shortcut to open a new instance instead of activating the running instance.

    Closing them in another matter.
    Michael

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts
    Hi Bill,

    easiest way to do this:

    Copy Excel.exe to Desktop

    Double click for every workbook that you want to open separately

    Open the workbook via Open Menu

    Wolfgang

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Do the solutions at http://answers.microsoft.com/en-us/o...3bf9d5c?auth=1 help at all?

    Steve

  5. #5
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 646 Times in 590 Posts
    Bill,

    The following code will add a selection to the right context menu that will open an Open Dialogue box to navigate to your file OR directly open the same file all the time.

    HTH,
    Maud

    context1.png

    Place the following code in the ThisWorkbook module:
    Code:
    Private Sub Workbook_Deactivate()
    'REMOVE CONTEXT ITEM WHEN CLOSING
        On Error Resume Next
                With Application
                    .CommandBars("Cell").Controls("openBook").Delete
                End With
        On Error GoTo 0
    End Sub
    
    Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
    'INSERT CONTEXT ITEM WHEN OPENING
    Dim Rcontext As CommandBarButton
        On Error Resume Next
            With Application
                .CommandBars("Cell").Controls("OpenBook").Delete
                Set Rcontext = .CommandBars("Cell").Controls.Add(Temporary:=True)
            End With
            With Rcontext
               .Caption = "OpenBook"
               .Style = msoButtonCaption
               .OnAction = "OpenBook"
            End With
        On Error GoTo 0
    End Sub
    If you want to navigate to your file then place the following code in a standard module:
    Code:
    Public Sub OpenBook()
    Application.DisplayAlerts = False
    Dim NewExcel As Excel.Application
    '--------------------------------------------------------
    'CREATE NEW INSTANCE OF EXCEL
    Set NewExcel = CreateObject("Excel.Application")
    NewExcel.Visible = True
    '--------------------------------------------------------
    'SET FILTERS AND OPEN DIALOGUE BOX
    Filter1 = "Excel file (*.xls*),*.xls*"
    Caption = "Please Select the File to Open"
    File = NewExcel.Application.GetOpenFilename(Filter1, , Caption) 'OPEN THE DIALGUE BOX AND GET THE FILE TO OPEN
    If File = "False" Then Exit Sub
    Workbooks.Open Filename:=File  'OPEN THE DESIRED FILE
    Application.DisplayAlerts = True
    End Sub
    If you want to consistently open the same file then paste the following code into a standard module:
    Code:
    Public Sub OpenBook()
    Dim NewExcel As Excel.Application
    Set NewExcel = CreateObject("Excel.Application")
    NewExcel.Visible = True
    '---------------------------------------------
    'CHANGE THE PATH TO THE FILE YOU WISH TO OPEN
    NewExcel.Workbooks.Open Filename:="C:\Users\Maudibe\Desktop\TestBook.xlsx"
    End Sub

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 646 Times in 590 Posts
    Is there a way to set up a right click choice on an explorer screen to give this as an option
    Bill,

    I am assumed you were talking about the right click context menu in Windows Explorer. I should have mentioned that the right context menu shown is from within your main Excel workbook so you can open a new instance of Excel without having to minimize and opening Windows Explorer. If the code is what you are looking to do, let me know if you do not know how to insert the codes into the modules.

    Maud
    Last edited by Maudibe; 2014-04-25 at 09:32.

  7. #7
    3 Star Lounger
    Join Date
    Apr 2012
    Posts
    240
    Thanks
    3
    Thanked 24 Times in 24 Posts
    I have a shortcut to Excel on my taskbar. I right click that and choose "Microsoft Excel" to open a new window.

    Windows 7, MS Office 2010.

    Doug

  8. #8
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    264
    Thanks
    32
    Thanked 5 Times in 5 Posts
    I think a right click context menu is what I am looking for too. But not from within Excel. If I have 3 excel workbooks and I want to open them in new instances of Excel, is there a way to add this to the right click menu from Windows Explorer?

  9. #9
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 646 Times in 590 Posts
    How about Right clicking the desktop and create a shortcut. in the field, enter exactly as written (win 7, 2010) but change your path and file:

    "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" C:\Users\Maudibe\Desktop\Book1.xlsx

    shortcut.png

    Change your Excel path if needed.

    You can also do this inside Windows Explorer by right clicking on the Excel.exe file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •