topic Cannot Export objects to bitmap files from multiple sheets in QlikView https://community.qlik.com/t5/QlikView/Cannot-Export-objects-to-bitmap-files-from-multiple-sheets/m-p/231717#M83424 <HTML><HEAD></HEAD><BODY><P>Try adding</P><P>ActiveDocument.GetApplication.WaitForIdle</P><P>before and after the exports.</P><P>-Rob</P></BODY></HTML> Fri, 05 Feb 2010 03:10:34 GMT rwunderlich 2010-02-05T03:10:34Z Cannot Export objects to bitmap files from multiple sheets https://community.qlik.com/t5/QlikView/Cannot-Export-objects-to-bitmap-files-from-multiple-sheets/m-p/231716#M83423 <HTML><HEAD></HEAD><BODY><P>I have a table in sheet1 and a chart in sheet2, and I want to use marco to export those 2 objects to 2 bitmap files.</P><P>I can only export the object in the active sheet but not the other sheet.</P><P>I tried to activate the sheet before export but it doesn't work</P><P>there is my code:</P><P>ActiveDocument.ActivateSheet 0</P><P>ActiveDocument.GetApplication.Refresh()</P><P>set myChart = ActiveDocument.GetSheetObject("CH01")</P><P>myChart.ExportBitmapToFile "C:\tempBMP1.bmp"</P><P></P><P>ActiveDocument.ActivateSheet 1</P><P>ActiveDocument.GetApplication.Refresh()</P><P>set myChart = ActiveDocument.GetSheetObject("CH02")</P><P>myChart.ExportBitmapToFile "C:\tempBMP2.bmp"</P><BR /><BR /> <P>set myChart = nothing</P><P></P><P>Any idea? thanks!</P></BODY></HTML> Fri, 05 Feb 2010 02:19:43 GMT https://community.qlik.com/t5/QlikView/Cannot-Export-objects-to-bitmap-files-from-multiple-sheets/m-p/231716#M83423 2010-02-05T02:19:43Z Cannot Export objects to bitmap files from multiple sheets https://community.qlik.com/t5/QlikView/Cannot-Export-objects-to-bitmap-files-from-multiple-sheets/m-p/231717#M83424 <HTML><HEAD></HEAD><BODY><P>Try adding</P><P>ActiveDocument.GetApplication.WaitForIdle</P><P>before and after the exports.</P><P>-Rob</P></BODY></HTML> Fri, 05 Feb 2010 03:10:34 GMT https://community.qlik.com/t5/QlikView/Cannot-Export-objects-to-bitmap-files-from-multiple-sheets/m-p/231717#M83424 rwunderlich 2010-02-05T03:10:34Z Cannot Export objects to bitmap files from multiple sheets https://community.qlik.com/t5/QlikView/Cannot-Export-objects-to-bitmap-files-from-multiple-sheets/m-p/231718#M83425 <HTML><HEAD></HEAD><BODY><P>It's work now! thanks a lot!</P></BODY></HTML> Fri, 05 Feb 2010 03:30:05 GMT https://community.qlik.com/t5/QlikView/Cannot-Export-objects-to-bitmap-files-from-multiple-sheets/m-p/231718#M83425 2010-02-05T03:30:05Z