topic Qv Macro CopytoClipboard Msg in QlikView https://community.qlik.com/t5/QlikView/Qv-Macro-CopytoClipboard-Msg/m-p/638843#M234178 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi All,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">I have a macro that generates reports in excel file from multiple qlikview charts,it generates more than 50 reports in different excel sheets.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">My issue here is sometimes while running the macro (while generating reports) it (QV) prompts message CopytoClipboard,which halts the macro to continue.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">To overcome this issue I added&nbsp; the code (ActiveDocument.GetApplication.WaitForIdle ,ActiveDocument.GetApplication.Sleep 5000) which will give some gap after every report is pasted in excel (for a smooth run),but with this also I didn't achieved and still sometimes showing the CopytoClipboard msg. </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Can anyone suggest how to overcome this.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Tom</SPAN></P></BODY></HTML> Tue, 20 May 2014 03:41:55 GMT thomas_skariah 2014-05-20T03:41:55Z Qv Macro CopytoClipboard Msg https://community.qlik.com/t5/QlikView/Qv-Macro-CopytoClipboard-Msg/m-p/638843#M234178 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi All,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">I have a macro that generates reports in excel file from multiple qlikview charts,it generates more than 50 reports in different excel sheets.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">My issue here is sometimes while running the macro (while generating reports) it (QV) prompts message CopytoClipboard,which halts the macro to continue.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">To overcome this issue I added&nbsp; the code (ActiveDocument.GetApplication.WaitForIdle ,ActiveDocument.GetApplication.Sleep 5000) which will give some gap after every report is pasted in excel (for a smooth run),but with this also I didn't achieved and still sometimes showing the CopytoClipboard msg. </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Can anyone suggest how to overcome this.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Tom</SPAN></P></BODY></HTML> Tue, 20 May 2014 03:41:55 GMT https://community.qlik.com/t5/QlikView/Qv-Macro-CopytoClipboard-Msg/m-p/638843#M234178 thomas_skariah 2014-05-20T03:41:55Z