i use VBA to copy the data in fileA, and paste in fileB, after exit file
A, there is a msgbox popup with contain as following:

click "yes" to save it (this memory) on clipboard
click "no" to delete from clipboard and free memory

how i click "no" by VBA in case ?

thank you for help.


--
vumian
------------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=566431

You can stop the prompt from show up by using:

application.cutcopymode = false

Before you close that file.

vumian wrote:

i use VBA to copy the data in fileA, and paste in fileB, after exit file
A, there is a msgbox popup with contain as following:

click "yes" to save it (this memory) on clipboard
click "no" to delete from clipboard and free memory

how i click "no" by VBA in case ?

thank you for help.

--
vumian
------------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=566431

--

Dave Peterson

hi man,

it's very good idea, thank you very much :)


--
vumian
------------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=566431