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

-----Original Message-----

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 save
etc.
I would like to get rid of these messages.

Any suggestions?


--
lorcanjc
----------------------------------------------------------
--------------
lorcanjc's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=3160
View this thread:
http://www.excelforum.com/showthread...hreadid=268107

.