clear the copy
 

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

--
ceem
-----------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065
View this thread: http://www.excelforum.com/showthread.php?threadid=54854

clear the copy
 

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

clear the copy
 

have you tried

application.cutcopymode = false

before you close the workbook

HTH

Duncan