excel programming

[dave glynn]

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

 

[Mike H]

Hi,

Application.displayalerts=false

close your file

Application.displayalerts=true

Mike

 

[Susan]

see your answers at your other post.
susan

 

[dave glynn]

Many thanks Gary worked perfectly

Thanks everyone

Kind regards

Dave