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]

hi man,

it's very good idea, thank you very much