Pop Up Messages when saving a file
 

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

--
lorcanj
-----------------------------------------------------------------------
lorcanjc's Profile: http://www.excelforum.com/member.php...nfo&userid=316
View this thread: http://www.excelforum.com/showthread.php?threadid=26810

Pop Up Messages when saving a file
 

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

.

Pop Up Messages when saving a file
 

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

Application.Displayalerts=False

....

Application.Displayalerts=True

Cheers, Pete

-----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

.