+ Reply to Thread
Results 1 to 3 of 3

Press ok on Msgbox when running a routine in another file

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    Amsterdam
    MS-Off Ver
    Excel 2013
    Posts
    72

    Press ok on Msgbox when running a routine in another file

    I have file1 which opens file2 and running a routine within file2. I loop that trough 350 file2 files

    Please Login or Register  to view this content.
    The problem i have is that the routine in file2 has 2 messageboxes.. which need to be ignored or be pressed on "Ok"

    **
    Application.DisplayAlerts = False doesn't work of course. Perhaps something with debug or Optional UserInteract As Boolean = True

    I am a bit out of ideas.

    *edit also the Continue or Edit links popup need to be triggered.

    Please Login or Register  to view this content.
    Last edited by Fean; 08-09-2019 at 05:07 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,236

    Re: Press ok on Msgbox when running a routine in another file

    Can you change the code in File2?
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    05-07-2013
    Location
    Amsterdam
    MS-Off Ver
    Excel 2013
    Posts
    72

    Re: Press ok on Msgbox when running a routine in another file

    Well then i have to open and change the 350 files..

+ 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. [SOLVED] Event Driven Macros stop running after running a routine macro
    By ChemistB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2017, 12:34 PM
  2. Running a sub-routine at timed intervals
    By ExcelBrain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2016, 06:02 PM
  3. EXCEL.exe running in background after routine has completed....
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-18-2014, 10:42 AM
  4. [SOLVED] Sub Routine running
    By mjwakema in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-10-2014, 10:47 AM
  5. Excel sometimes crashes when running a sub routine
    By Brunstgnegg in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 08-20-2010, 06:55 AM
  6. Macro Running Very Slow - Cell (press esc to cancel)
    By taylormade58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2009, 06:25 PM
  7. How to prevent routine from running on certain sheets
    By Gary Paris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2005, 12: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