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

--
FuzzyDov
-----------------------------------------------------------------------
FuzzyDove's Profile: http://www.excelforum.com/member.php...fo&userid=1667
View this thread: http://www.excelforum.com/showthread.php?threadid=31889

Try turning off alerts. E.g.,

Application.DisplayAlerts = False
' your code here
Application.DisplayAlerts = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"FuzzyDove" wrote in
message ...

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

application.displayalerts=False
'do the save/overwrite
application.displayalerts=True



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


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

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