how to ignore memory copied ?

[vumian]

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.

[Dave Peterson]

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

[vumian]

hi man,

it's very good idea, thank you very much