Thread: When Wanting To Replace Previously Saved .xls File
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stephen Bullen[_4_] Stephen Bullen[_4_] is offline
external usenet poster
  
Posts: 205
Default When Wanting To Replace Previously Saved .xls File
Hi Chuckles123,

Is there any way to do this in VBA code so that the user is not prompted
with the 'Replace?' Question?

Yes, put:

Application.DisplayAlerts = False

before the Save As, and

Application.DisplayAlerts = True

after it.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk


Reply With QuoteReply With Quote