clear the copy

[ceemo]

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

 

[james.billy]

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

 

[Duncan]

have you tried

application.cutcopymode = false

before you close the workbook

HTH

Duncan