topic problem ExportBitmaptofile v9 in QlikView

problem ExportBitmaptofile v9

bonaiti — Fri, 07 May 2010 13:49:38 GMT

Hello.

I'm a problem with this function. Now i use the QV 8.2 and this macro is ok. I create a bmp and i open the file with the sheet. It's OK

Sub Esporta
stringa = "C:\PortafoglioNastro.bmp"
ActiveDocument.ActivateSheet(1)
ActiveDocument.ActiveSheet.ExportBitmapToFile(stringa)
End Sub

I open the same file with QV 9.0 SR4 / SR3 .... and the macro run, but the file bmp created is all blank. i don't know why.......[:S]

is it a BUG? or something else?

Thank you.

Robert

bonaiti — Fri, 07 May 2010 14:22:10 GMT

ALSO THIS

http://community.qlik.com/forums/t/28099.aspx

IT's a BUG I Think !!!!!!!!!!

kji — Fri, 07 May 2010 14:30:16 GMT

Try this:

Sub Esporta
stringa = "C:\PortafoglioNastro.bmp"

ActiveDocument.ActivateSheet(1)

ActiveDocument.GetApplication().WaitForIdle

ActiveDocument.ActiveSheet.ExportBitmapToFile(stringa)
End Sub

Adding the WaitForIdle call will give the sheet time to repaint before doing the export.

bonaiti — Fri, 07 May 2010 14:41:59 GMT

IT WORK!!!

Thank you