topic Macro to export entire sheet in QlikView https://community.qlik.com/t5/QlikView/Macro-to-export-entire-sheet/m-p/619441#M228153 <HTML><HEAD></HEAD><BODY><P>I have a macro as a button action which exports a sheet to an image file:</P><P></P><P></P><P>sub SendImage</P><P></P><P></P><P></P><P>ActiveDocument.ActiveSheet.ExportBitmapToFile&nbsp; "C:\\MyFile.jpg"</P><P></P><P>ActiveDocument.Sheets("SH01").ExportBitmapToFile "C:\\MyFile2.jpg"</P><P></P><P></P><P></P><P>end sub </P><P></P><P>The 1st image (created from the active sheet) is fine but the 2nd image (created from a different non-active sheet) is blank. I don't want to put the button on the sheet I wish to print, otherwise it will be included on the image !</P><P>Can anyone explain what is wrong with the second line of my macro?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 09 Apr 2014 13:32:45 GMT richard_chilvers 2014-04-09T13:32:45Z Macro to export entire sheet https://community.qlik.com/t5/QlikView/Macro-to-export-entire-sheet/m-p/619441#M228153 <HTML><HEAD></HEAD><BODY><P>I have a macro as a button action which exports a sheet to an image file:</P><P></P><P></P><P>sub SendImage</P><P></P><P></P><P></P><P>ActiveDocument.ActiveSheet.ExportBitmapToFile&nbsp; "C:\\MyFile.jpg"</P><P></P><P>ActiveDocument.Sheets("SH01").ExportBitmapToFile "C:\\MyFile2.jpg"</P><P></P><P></P><P></P><P>end sub </P><P></P><P>The 1st image (created from the active sheet) is fine but the 2nd image (created from a different non-active sheet) is blank. I don't want to put the button on the sheet I wish to print, otherwise it will be included on the image !</P><P>Can anyone explain what is wrong with the second line of my macro?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 09 Apr 2014 13:32:45 GMT https://community.qlik.com/t5/QlikView/Macro-to-export-entire-sheet/m-p/619441#M228153 richard_chilvers 2014-04-09T13:32:45Z