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

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

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