View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default excel programming

Let's try two thing:

1. a simple lie
2. a request not to be bothered

Sub dural()
ActiveWorkbook.Saved = True
Application.DisplayAlerts = False
ActiveWorkbook.Close
End Sub

--
Gary''s Student - gsnu200827


"dave glynn" wrote:

I have a vba procedure that closes "n" number of files; each time it is about
to delete the file it forces me to respond manually to confirm that I do want
to close it. To an extent this defeats the purpose of programming in the
first place.

Likewise when I want to save the file at various stages similar
confirmations are required.

Is there any way to avoid these interventions?

With thanks

Dave