Pop Up Messages when saving a file

[lorcanjc]

I have a macro which selects data from a particular tab within excel.
It pastes this data into a new sheet and saves this as a text file.

The problem I have is that messages pop requesting confirmation to sav
etc.
I would like to get rid of these messages.

Any suggestions

 

[Frank Kabel]

H
use
....
application.displayalerts=false
'your saving code
application.displayalerts=true
....

 

[Pete McCosh]

To suppress pop-ups of this nature, enclose your code in
these lines:

Application.Displayalerts=False

....

Application.Displayalerts=True

Cheers, Pete