Discussion Board for collaboration related to QlikView App Development.
I'm in trouble with a macro that creates a PPT.
Everything WORKS fine till I select a field.
I'm going to explain my problem.
I have a sheet with a pivot table.
If I don't select a field the Macro works perfectly and create 30 PPT'S with a slide containing my pivot table.
if instead, I select a field of my cloud, the macro goes in error.
The error is in this line of code
I tried using
but if I insert these two rows I get an error in the line
I tried adding
I tired using SLEEP
So I can't use ActiveDocument.GetApplication.WaitForIdle
The strange thing is that if i put a msgbox ("HI")
just before the line
I say it again. I have this problem ONLY if i select a field. EVERY Field of my cloud.
Someone can help me
I'm going craizy.
My Qlik Version is 11.20.11643.0 IR
Thank you in advance
I solved the problem.
I was testing the macro using the button TEST.
Creating a button with action my Macro everything went ok.
I don't know why this happen but hope this thread can be useful to someone else.
The ActiveDocument.GetApplication.WaitForIdle command is working fine too in this way.
Thank you all