Images Cannot be Displayed During Macro Execution

[#1]

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]

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

[#3]

Hi Johannes,

I got below error message:

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

[Anonymous]

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

[Gysbert_Wassenaar]

Try adding these lines:

set QV =  ActiveDocument.GetApplication

QV.WaitForIdle

QV.Refresh

[#6]

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