topic Macro statements' execution order in QlikView https://community.qlik.com/t5/QlikView/Macro-statements-execution-order/m-p/971140#M332456 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to write a macro which exports 2 images of different sheets for every value selected on a field.</P><P>I used macros a lot but this time I can't understand the code execution's behaviour. It seems that the statements of my function are not executed in the correct sequence.</P><P>For example, I have to activate a sheet and then export it as an image file. (I'm using this horrible practice because ActiveDocument.GetSheetByID("SHxx").ExportBitmapToFile and ActiveDocument.Sheets("sheet name").ExportBitmapToFile don't work if active sheet isn't the same I have to export... another VBS mystery).</P><P>Well, the statement which would export the sheet runs before the statement that has to activate the correct sheet and if I insert a wait of x seconds between the two statements, QlikView client stays locked for x seconds before the image is generated and only then the correct sheet is activated.</P><P>Have you ever had issues like this before? How can I control the correct sequence of statements forbidding execution of one before the previous has finished?</P><P>Thanks.</P><P></P><P>MR</P></BODY></HTML> Tue, 10 Nov 2015 17:06:15 GMT mrossoit 2015-11-10T17:06:15Z Macro statements' execution order https://community.qlik.com/t5/QlikView/Macro-statements-execution-order/m-p/971140#M332456 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to write a macro which exports 2 images of different sheets for every value selected on a field.</P><P>I used macros a lot but this time I can't understand the code execution's behaviour. It seems that the statements of my function are not executed in the correct sequence.</P><P>For example, I have to activate a sheet and then export it as an image file. (I'm using this horrible practice because ActiveDocument.GetSheetByID("SHxx").ExportBitmapToFile and ActiveDocument.Sheets("sheet name").ExportBitmapToFile don't work if active sheet isn't the same I have to export... another VBS mystery).</P><P>Well, the statement which would export the sheet runs before the statement that has to activate the correct sheet and if I insert a wait of x seconds between the two statements, QlikView client stays locked for x seconds before the image is generated and only then the correct sheet is activated.</P><P>Have you ever had issues like this before? How can I control the correct sequence of statements forbidding execution of one before the previous has finished?</P><P>Thanks.</P><P></P><P>MR</P></BODY></HTML> Tue, 10 Nov 2015 17:06:15 GMT https://community.qlik.com/t5/QlikView/Macro-statements-execution-order/m-p/971140#M332456 mrossoit 2015-11-10T17:06:15Z Re: Macro statements' execution order https://community.qlik.com/t5/QlikView/Macro-statements-execution-order/m-p/971141#M332457 <HTML><HEAD></HEAD><BODY><P>ActiveDocument.GetApplication.WaitForIdle</P></BODY></HTML> Tue, 10 Nov 2015 17:12:40 GMT https://community.qlik.com/t5/QlikView/Macro-statements-execution-order/m-p/971141#M332457 m_woolf 2015-11-10T17:12:40Z