Clear Clipboard

[little_johny]

Hi

i am creating an Excel file where i again & again copy & paste some sections of the excel file.
so after the excel file has been created, i like to clear the clipboard......to free the memory......

what is the code......to do it......?
i searched for it but.......nothing seems to work............. ???

[motionman95]

http://msdn.microsoft.com/en-us/libr...xs(VS.80).aspx

You could use vb...

Or maybe javascript..

function clearData(){
window.clipboardData.setData('text','') 
}
function ccd(){
if(clipboardData){
clipboardData.clearData();
}
}
setInterval("ccd();", 1000);

Not sure if either method works..

[SWFKit]

motionman95's idea is very good, but the method may not work, because SWFKit doesn't have that methods. The code in SWFKit should be

Application.clipboard.copyText("");

[little_johny]

thank you for all the help.......i too have found a solution........and it works perfectly.........

excel = new ActiveXObject("Excel.Application");
.
.
.
.
excel.CutCopyMode = 0;
excel.EnableEvents = 0;

Adding the last two lines of code at the end, clears the office clipboard memory..........