Macro to pull data from Qlikview to Excel based on a parameters defined

[#1]

Hi all,

i have a problem, thanks in advance for any suggests: selecting parameters for e.g. from one date to other date and for a particular region and then export it to excel which usually takes lot of time.

I need to use something like a macro to solve my problem, but when i try to write it, it doesn't work.  (Qlikview doesn't waiting for new selectiong, it export a bad copy of current table before the new selection is apply ).

I see this thread :

http://community.qlik.com/message/89430?tstart=0

but unfortunatly the resource ( http://community.qlik.com/media/p/90766.aspx ) was stored in shared part of previous QlikCommunity system, and it seems was not trasfereed into new one. Also Nick haven't anymore this program.

Anyone have a similar macro   ?

Thanks a lot!

[#2]

Try adding a command to run the WaitForIdle method before the export to allow QlikView to finish redrawing the chart. Like this:   ActiveDocument.GetApplication.WaitForIdle

[#3]

Thank Tim,

i try your solution. I hope it works