topic Macro to export graphs from different sheets objects with a single button in QlikView https://community.qlik.com/t5/QlikView/Macro-to-export-graphs-from-different-sheets-objects-with-a/m-p/1394172#M423466 <HTML><HEAD></HEAD><BODY><P>I have created a macro to export objects from a single sheet. I now need to export objects from multiple sheets with a single button.</P><P>I have copied the same button to all other sheets wherever I need to export these objects. But when I click on the button in one sheet it only exports the object present on that sheet and doesn't export the objects from other sheets despite this being written in the macro</P><P></P><P>Pasted below are the different Sheet object numbers. so ideally it should be exporting these images from different sheets at the same time.</P><P></P><P></P><P>ActiveDocument.Sheets("Sheet3").SheetObjects("CH254").ExportBitmapToFile "C:\Users\43862460\Reports\WIP\TestImages\Weekly_Aging_" &amp; expSelection(i).Text &amp; ".jpg"<BR /> ActiveDocument.Sheets("Sheet4").SheetObjects("CH257").ExportBitmapToFile "C:\Users\43862460\Reports\WIP\TestImages\SLA_" &amp; expSelection(i).Text &amp; ".jpg"<BR /> </P><P>I need to go to each sheet and then click on the button to export instead of a single click...can somebody please explain why this is happening</P></BODY></HTML> Wed, 04 Oct 2017 11:48:28 GMT Anonymous 2017-10-04T11:48:28Z Macro to export graphs from different sheets objects with a single button https://community.qlik.com/t5/QlikView/Macro-to-export-graphs-from-different-sheets-objects-with-a/m-p/1394172#M423466 <HTML><HEAD></HEAD><BODY><P>I have created a macro to export objects from a single sheet. I now need to export objects from multiple sheets with a single button.</P><P>I have copied the same button to all other sheets wherever I need to export these objects. But when I click on the button in one sheet it only exports the object present on that sheet and doesn't export the objects from other sheets despite this being written in the macro</P><P></P><P>Pasted below are the different Sheet object numbers. so ideally it should be exporting these images from different sheets at the same time.</P><P></P><P></P><P>ActiveDocument.Sheets("Sheet3").SheetObjects("CH254").ExportBitmapToFile "C:\Users\43862460\Reports\WIP\TestImages\Weekly_Aging_" &amp; expSelection(i).Text &amp; ".jpg"<BR /> ActiveDocument.Sheets("Sheet4").SheetObjects("CH257").ExportBitmapToFile "C:\Users\43862460\Reports\WIP\TestImages\SLA_" &amp; expSelection(i).Text &amp; ".jpg"<BR /> </P><P>I need to go to each sheet and then click on the button to export instead of a single click...can somebody please explain why this is happening</P></BODY></HTML> Wed, 04 Oct 2017 11:48:28 GMT https://community.qlik.com/t5/QlikView/Macro-to-export-graphs-from-different-sheets-objects-with-a/m-p/1394172#M423466 Anonymous 2017-10-04T11:48:28Z