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