+ Reply to Thread
Results 1 to 3 of 3

Open different Excel file in a new instance with vba

  1. #1
    Registered User
    Join Date
    12-26-2019
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    69

    Open different Excel file in a new instance with vba

    Hi everyone,

    Hope you are all doing well.
    I have this code which works great in creating an excel file in a new instance.

    Please Login or Register  to view this content.
    What I would like however is, to click on a button which opens the open file explorer dialogue, select an Excel file of my choice and open that file when clicked in a new instance.

    If that is possible, could you share the vba code with me?

    Thank you very much in advance.
    Last edited by Pepe Le Mokko; 01-09-2020 at 04:21 AM. Reason: Remove unnecessary title part

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    1,935

    Re: Open different Excel file in a new instance with vba

    You could use the file dialog

    Please Login or Register  to view this content.
    Last edited by ByteMarks; 01-09-2020 at 08:32 AM.

  3. #3
    Registered User
    Join Date
    12-26-2019
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    69

    Re: Open different Excel file in a new instance with vba

    Oh wow, amazing. Works like magic. Exactly what i was looking for. Thank you so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Shortcut to open a file in a new instance of Excel
    By cn198 in forum Excel General
    Replies: 6
    Last Post: 10-18-2019, 01:58 PM
  2. Open specific file in new instance of excel upon opening
    By c.davidson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2018, 09:07 AM
  3. [SOLVED] How to open new instance of an excel file from batch?
    By bg18461 in forum Excel General
    Replies: 1
    Last Post: 04-25-2014, 07:51 PM
  4. Open New Instance Of Excel With Named File
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-09-2007, 10:25 PM
  5. Replies: 4
    Last Post: 09-07-2005, 12:05 AM
  6. Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1