Results 1 to 9 of 9

Auto close 'overwrite existing data' box

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2020
    Location
    Vilnius, Lithuania
    MS-Off Ver
    MS Office 2010
    Posts
    20

    Auto close 'overwrite existing data' box

    I am very new to excel's macros and vba coding...

    I've made my first macro to run 16 regressions, but 16 times I get the warning box for overwriting existing data, so I have to click OK button 16 times in a row and it annoys me.

    Application.DisplayAlerts = False
    I tried this solution, put it everywhere in the script but it doesn't help.

    Any ideas?

    Thanks!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by paupaj; 10-19-2020 at 03:45 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. overwrite / clear existing data before copying
    By scouse13 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2020, 12:37 PM
  2. Adding auto-close code to existing?
    By barbd777 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 07-25-2016, 06:51 PM
  3. MACRO to split new data into multiple tabs but not overwrite existing data
    By amo899115 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-11-2016, 01:42 PM
  4. [SOLVED] Userform Have Text Boxes Auto Populate Based on Combobox Selection & overwrite existing da
    By Rajesh shishodia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2015, 02:06 AM
  5. [SOLVED] VBA to Promt if PDF exists and to overwrite - Close Existing File first
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2014, 03:09 AM
  6. Split data from Master Sheet to existing worksheets and overwrite data
    By vmwest in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-21-2013, 05:36 PM
  7. Overwrite existing data
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2012, 09:10 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