Hi, I tried your code and I got an error even before you got it.
I created a sample app with two different macros based in your code.
With a little adjustment in it I was able to export, but only when there was a selection in the field.
I created a second macro where you can export all posible values (user can make selection on otherf fields, and we don't export anything if it is not related).
Please, don't mind the charts, they don't make any sense. I was just using this to study the macro.
Hope it works for you.
QV 9 is really different from QV 8, your code will function well in QV 8.
Please add a line code as following:
set image = ActiveDocument.GetSheetObject("CH02")
I met this issue before and got offical reply as above.
May it will help you.
Has anyone come up with a solution for this in QlikView 11.2? I have tried ActiveDocument.ClearCache, ActiveDocument.GetApplication.WaitForIdle 50 (and other parameters), but the macro I am working with still stops at CopyBitmapToClipboard when trying to loop through multiple objects and export them to Excel.