PDA

View Full Version : SaveAs question



next
02-29-2008, 04:13 PM
Ho do i get rid of "do you want to overwrite existing file?" message?
I want to set it to "overwrite always", how do i do that?

Thanks.

tstav
02-29-2008, 04:19 PM
Add

Application.DisplayAlerts=False
before the save , and

Application.DisplayAlerts=True
right after the save

next
02-29-2008, 04:28 PM
Thanks!