#1
|
|||
|
|||
Automating code in Maco
Hi All, I have a code that takes information from a few sheets in a workbook and transfers it to a few other workbooks on the Network. When I run the Macro a dialog box comes up that says (Do you want to overwrite file?). Yes No Cancel I understand why it does it because I am overwriting a file. Is there a code that I can insert into my code that would click the Yes button so I don't have to say yes every time it pops up. Thanks in advance!!! |
#2
|
|||
|
|||
Try
Application.DisplayAlerts = False Before you exit Application.DisplayAlerts = True |
#3
|
|||
|
|||
Works Great!!! Thanks
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
automating a repetitive process | vthomeschoolmom | Excel Programming | 1 | 02-28-2012 07:41 PM |
automating insertion of some text | obrienaj | Word | 3 | 10-17-2011 11:50 AM |
Automating Outlook from Access | RMittelman | Outlook | 1 | 02-07-2011 03:11 PM |
Automating an address from an Abbreviation | Panzer | Word | 0 | 04-12-2010 06:11 AM |
Automating Cel Population of .jpg | skoz55 | Excel | 0 | 01-21-2009 03:43 AM |