Try rapping...
Application.DisplayAlerts = False 'turn warnings off
and
Application.DisplayAlerts = True 'turn warnings on
around the code that replaces the file.
HTH,
Gary Brown


"FuzzyDove" wrote:


I'm working on a little bit VBA that, one by one, opens hundreds of
existing xls files, compares the sheet names then adds some sheets of
new data as needed. It then re-saves (replaces) the original file with
the one that has the new sheets of data. The problem that I desparately
need help with, is that every time it goes to save the file, Excel pops
up a box asking me if I want to replace the existing file (which clearly
I do). However, this needs to be an automated process so I can't sit
there for 3 hours clicking yes to each of the hundreds of files. Does
anybody know how I can get VBA/Excel to replace the file without being
prompted each time?? (by the way, the SaveChanges does not help such
as: Workbooks("BOOK1.XLS").Close SaveChanges:=True does not help).
Thanks HEAPS for any suggestions or help!!
FuzzyDove


--
FuzzyDove
------------------------------------------------------------------------
FuzzyDove's Profile: http://www.excelforum.com/member.php...o&userid=16676
View this thread: http://www.excelforum.com/showthread...hreadid=318894