Try this:

Activewindow.Close saveChanges:=False



(dsan) wrote in message . com...
Using VBA I have copied data from a .xls file to a second Excel file
that I have saved as .txt. Having already saved the file is there
anyway that I can suppress the message "Do you wish to save the
changes made to ' .... .txt'?" when I use the command
ActiveWindow.Close to remove the text file from my workspace?