+ Reply to Thread
Results 1 to 5 of 5

Excel VB code. Message pops up while code running asking question. Code must not wait.

  1. #1
    Registered User
    Join Date
    08-20-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    16

    Excel VB code. Message pops up while code running asking question. Code must not wait.

    Hey guys.

    I have a Excel VB code that looks at multiple sheets but it stops to ask me do I want to reopen the sheet etc. I need this code to run without asking me questions. What can I add into the code to force it to run without asking me questions?

    I'm not sure if it will display the image I attached but it pops up after opening each file with the following: file name.xls is already open. Ropening will cause any changes you made to be discarded. Do you want to reopen file name.xls yes or no.

    This is quite strange as I was running this code in Excel 2003 and it didn't give me problems but now I have 2013 pro version. It looks like it does it on the same file. I need to grab and info from different sections in each file and place them in rows next to each other. Please remember that this worked in an earlier version of excel.

    I see now it asks me 5 times per file if I want to reopen the file with every loop it runs. Do you maybe have a section of code I can add to my current code to just go ahead and reopen?

    This code looks thru hundreds of excel files and I cannot sit and click yes yes yes yes lol.

    Please see code below.

    Please Login or Register  to view this content.
    Thank you all for the help.
    Attached Images Attached Images
    Last edited by Heinrich Venter; 09-28-2014 at 06:00 AM.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel VB code. Message pops up while code running asking question. Code must not wait.

    Like so:

    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    08-20-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Excel VB code. Message pops up while code running asking question. Code must not wait.

    Thank you so much I will try it now ;-)

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel VB code. Message pops up while code running asking question. Code must not wait.

    Let me know...

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Registered User
    Join Date
    08-20-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Excel VB code. Message pops up while code running asking question. Code must not wait.

    Awesome ...... thank you so much JBeaucaire you are the MAN.

+ 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] Code not running properly! Getting error message
    By mwolfe571 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2013, 02:01 PM
  2. Running excel vba code from inside access vba code
    By Lanox in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2011, 09:09 AM
  3. Code the saves filter info to reapply after running other code
    By Wedge120 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-25-2011, 05:49 PM
  4. suppress Excels message boxes when a VB code is running
    By Bill-E-BoB in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2007, 03:33 PM
  5. Pause code, wait for input, no input received, carry on with the code
    By johnd@arm.co.uk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2005, 08:05 AM

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