problem ExportBitmaptofile v9

[bonaiti]

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 · Accepted solution]

ALSO THIS

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

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

[kji]

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]

IT WORK!!!

Thank you