+ Reply to Thread
Results 1 to 3 of 3

Open workbook in new instance of excel

  1. #1
    Registered User
    Join Date
    07-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2097
    Posts
    2

    Open workbook in new instance of excel

    I have a solution I developed that opens from “Workbook_Open” and immediately shows a userform and makes the application not visible. The entire solution is run in userforms. The issue is if the user already has excel open the solution opens and makes their current workbook not visible. I would like the solution to determine if excel is already ope and if it is open in a new instance of excel.

  2. #2
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Open workbook in new instance of excel

    Please Login or Register  to view this content.
    This opens a new instance of excel. If someone runs your "solution", wouldnt that meant that he has excel already open? Or do you mean that he has another workbook open?
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  3. #3
    Registered User
    Join Date
    07-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2097
    Posts
    2

    Re: Open workbook in new instance of excel

    I think that is going in the direction I want to go. What I need to happen is when a user already has an excel workbook open and they double click on my excel workbook solution, my workbook will open in a new instance of excel because my workbook solution makes the excel workbook invisible and runs with user forms. Thank you for your help. If you have an idea for me I would appreciate the help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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