topic Clear clipboard in QlikView https://community.qlik.com/t5/QlikView/Clear-clipboard/m-p/419406#M156059 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Does anyone know how to clear the clipboard after you copy a table? I am using:</P><P></P><P></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>ActiveDocument.GetSheetObject("CH09").CopyTableToClipboard true<BR /><BR /> XLDoc.Sheets(1).Paste() </P><P></P><P></P><P></P><P style="text-align: left;">But now I need to clear the clipboard and copy a different object. Help?</P></BODY></HTML> Tue, 18 Sep 2012 21:26:47 GMT 2012-09-18T21:26:47Z Clear clipboard https://community.qlik.com/t5/QlikView/Clear-clipboard/m-p/419406#M156059 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Does anyone know how to clear the clipboard after you copy a table? I am using:</P><P></P><P></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>ActiveDocument.GetSheetObject("CH09").CopyTableToClipboard true<BR /><BR /> XLDoc.Sheets(1).Paste() </P><P></P><P></P><P></P><P style="text-align: left;">But now I need to clear the clipboard and copy a different object. Help?</P></BODY></HTML> Tue, 18 Sep 2012 21:26:47 GMT https://community.qlik.com/t5/QlikView/Clear-clipboard/m-p/419406#M156059 2012-09-18T21:26:47Z Re: Clear clipboard https://community.qlik.com/t5/QlikView/Clear-clipboard/m-p/419407#M156060 <HTML><HEAD></HEAD><BODY><P>I don't think there's a direct approach to clearing the clipboard using vbscript. </P><P>Why don't you just copy the next object and it will overwrite CH09 on the clipboard?</P></BODY></HTML> Wed, 19 Sep 2012 00:47:06 GMT https://community.qlik.com/t5/QlikView/Clear-clipboard/m-p/419407#M156060 Anonymous 2012-09-19T00:47:06Z Re: Clear clipboard https://community.qlik.com/t5/QlikView/Clear-clipboard/m-p/419408#M156061 <HTML><HEAD></HEAD><BODY><P>That's what is weird. When I copy the next object, it doesn't override the last object and pastes the original object instead. The only solution I can think is to somehow clear the clipboard or use two macros, which I would prefer to avoid.</P></BODY></HTML> Wed, 19 Sep 2012 13:01:44 GMT https://community.qlik.com/t5/QlikView/Clear-clipboard/m-p/419408#M156061 2012-09-19T13:01:44Z