clear the copy

i have some code which i use to open another workbook, copy in some daat and then close it after but this creates a pop up asking if i wish to keep the data for pasting in later. Is there some code i can use to clear the copy without the pop up?

Hi Ceemo,

You could try Application.CutCopyMode = False, this I think clears it
another alternative is to switch warnings off, ie
Application.DisplayAlerts = False which would not prompt about clearing
the data IF you use this method remember to switch it back on at the
end of your code ie Application.DisplayAlerts = True.

Cheers,

James

ceemo wrote:
> i have some code which i use to open another workbook, copy in some daat
> and then close it after but this creates a pop up asking if i wish to
> keep the data for pasting in later. Is there some code i can use to
> clear the copy without the pop up?
>
>
> --
> ceemo
> ------------------------------------------------------------------------
> ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
> View this thread: http://www.excelforum.com/showthread...hreadid=548547

have you tried

application.cutcopymode = false

before you close the workbook

HTH

Duncan