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
|