topic Re: Images Cannot be Displayed During Macro Execution in QlikView

Images Cannot be Displayed During Macro Execution

Mon, 26 Nov 2012 09:08:29 GMT

Dear All,

I have a straight table which has one dimension as company logos. I want to send that table to a specific email address with a macro.

When I add a trigger to execute the macro after reload process, the embedded images cannot be present correctly.

Are there any way to stop the macro after reload for a while to make the images available and than run it again.

I use the below macro to export the snapshot of the table:

Sub Snapshot

Set obj = ActiveDocument.ActiveSheet.SheetObjects("CH27")

obj.ExportBitmapToFile "C:\\Dashboards\\Executive_Dashboard\\ExecutiveDashboard.jpg"

End Sub

Thanks for your support, best regards.

Anonymous — Mon, 26 Nov 2012 09:10:10 GMT

Hi, you could try adding an: ActiveDocument.WaitForIdle and see if that allows the images to be generated before the macro continues.

Mon, 26 Nov 2012 09:38:09 GMT

Hi Johannes,

I got below error message:

"Object doesn't support this property or method: 'ActiveDocument.WaitForIdle'"

Anonymous — Mon, 26 Nov 2012 09:41:34 GMT

My bad, it's actually: ActiveDocument.GetApplication.WaitForIdle

Gysbert_Wassenaar — Mon, 26 Nov 2012 09:45:57 GMT

Try adding these lines:

set QV = ActiveDocument.GetApplication

QV.WaitForIdle

QV.Refresh

Mon, 26 Nov 2012 09:50:08 GMT

Hi Gysbert,

I try your suggestion but I'm still having qmem... instead of images.

I think embedded images cannot be displayed until macro execution ended.

Do you have any suggestion.

Kind Regards,

Asim Akin