Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
ALSO THIS
http://community.qlik.com/forums/t/28099.aspx
IT's a BUG I Think !!!!!!!!!!
ALSO THIS
http://community.qlik.com/forums/t/28099.aspx
IT's a BUG I Think !!!!!!!!!!
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.
IT WORK!!!
Thank you