Hello QV Users,
I have a document where I need to export multiple sheets to image files. I have the macro to export the sheet correct (macro below) but only the sheet that is active exports correctly. The other sheet that is not active exports as a blank image.
Macro:
sub exportToFolder
GraphPath = '\\smdapp02\Qlikview\Models'
ActiveDocument.Sheets("Dashboard").ExportBitmapToFile GraphPath & "A.jpg"
ActiveDocument.Sheets("Master Dashboard").ExportBitmapToFile GraphPath & "B.jpg"
end sub
Please could someome help me with this. I would really appreciate it.
Thanks,
S
