+ Reply to Thread
Results 1 to 3 of 3

Opening another excel file while macros are running on another

  1. #1
    Registered User
    Join Date
    12-30-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    20

    Opening another excel file while macros are running on another

    Scenario:-
    I am running macros on an excel file X
    but then i want to open another file Y from a folder 'zz'. This i will open directly from the folder by double clicking the file (i do not want to use macros for this).
    Is this possible?

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Opening another excel file while macros are running on another

    Try opening a separate Excel instance (start Excel a second time from the Start menu or from a shortcut on your desktop) and then open the second file from within that second Excel window.

    Lewis

  3. #3
    Registered User
    Join Date
    12-30-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Opening another excel file while macros are running on another

    Thanks Lewis. It worked.

+ 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. Opening ANY file with Macros causes Excel to Hang
    By ERGOTRONIT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2008, 02:32 PM
  2. [SOLVED] Running Macros without opening file.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2006, 02:56 AM
  3. Running Dialog Sheet when opening Excel File
    By Yacov in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2005, 01:05 PM
  4. [SOLVED] Running Macros when opening Excel
    By Neil Hopkinson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2005, 11:06 AM
  5. [SOLVED] Trouble opening an Excel file that contains macros
    By JohnR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-08-2005, 04:06 PM

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