topic URGENT MACRO HELP! in QlikView https://community.qlik.com/t5/QlikView/URGENT-MACRO-HELP/m-p/440524#M164194 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a macro that takes a screen shot of a sheet and then sends it to excel. However, if the model is not active on the sheet, it cant take a screenshot. It come through blank. I have tried ActiveDocument.GetSheet("").Activate before the screenshot to activate the sheet but it doesnt work.</P><P></P><P>Any Ideas?</P></BODY></HTML> Wed, 05 Jun 2013 08:24:56 GMT 2013-06-05T08:24:56Z URGENT MACRO HELP! https://community.qlik.com/t5/QlikView/URGENT-MACRO-HELP/m-p/440524#M164194 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a macro that takes a screen shot of a sheet and then sends it to excel. However, if the model is not active on the sheet, it cant take a screenshot. It come through blank. I have tried ActiveDocument.GetSheet("").Activate before the screenshot to activate the sheet but it doesnt work.</P><P></P><P>Any Ideas?</P></BODY></HTML> Wed, 05 Jun 2013 08:24:56 GMT https://community.qlik.com/t5/QlikView/URGENT-MACRO-HELP/m-p/440524#M164194 2013-06-05T08:24:56Z Re: URGENT MACRO HELP! https://community.qlik.com/t5/QlikView/URGENT-MACRO-HELP/m-p/440525#M164195 <HTML><HEAD></HEAD><BODY><P>To activate a sheet use something like:</P><P>ActiveDocument.Sheets("Main").Activate</P><P></P><P>This should create a 'screenshot' of the sheet with the name Main:</P><P>ActiveDocument.Sheets("Main").CopyBitmapToClipboard</P></BODY></HTML> Wed, 05 Jun 2013 09:06:26 GMT https://community.qlik.com/t5/QlikView/URGENT-MACRO-HELP/m-p/440525#M164195 Gysbert_Wassenaar 2013-06-05T09:06:26Z Re: URGENT MACRO HELP! https://community.qlik.com/t5/QlikView/URGENT-MACRO-HELP/m-p/440526#M164196 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>I have managed to sort of the Activate part, although I need a timeout period to allow the sheet to activate. I have tried:</P><P>" ActiveDocument.GetApplication.WaitForIdle 1000 " but Qlikview seems to hang on waitforidle. Seems to be a bug.</P><P></P><P>Any way around that?</P></BODY></HTML> Wed, 05 Jun 2013 09:09:48 GMT https://community.qlik.com/t5/QlikView/URGENT-MACRO-HELP/m-p/440526#M164196 2013-06-05T09:09:48Z