I have a macro that generates reports in excel file from multiple qlikview charts,it generates more than 50 reports in different excel sheets.
My issue here is sometimes while running the macro (while generating reports) it (QV) prompts message CopytoClipboard,which halts the macro to continue.
To overcome this issue I added 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.
