excel programming
 

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

excel programming
 

Hi,

Application.displayalerts=false

close your file

Application.displayalerts=true

Mike

"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

excel programming
 

see your answers at your other post.
susan


On Jan 15, 2:49*pm, 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

excel programming
 

Many thanks Gary worked perfectly

Thanks everyone

Kind regards

Dave

"Gary''s Student" wrote:

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