Messagebox

[#1]

Hey,

Ive got another question :

I'm using Qlikview 10 and i'm writing a macro which generates charts in excel and pdf files.

I'm showing a messagebox in my macro but i want that the messagebox dissapears in 5 seconds

if nobody clicks on the button "OK".

I tried :

WsShell.Popup("Loading charts", _

'5)

ActiveDocument.GetApplication.WaitForIdle 5000

I just want the script to wait a few seconds so it can generate my charts, if not i get a white rectangle instead of a chart.

If i work with a messagebox and i click on "OK" it generates my charts.

So any suggestions to make this work?

If you don't understand my question feel free to ask

Hope someone can help me

[#2]

thx for the answers,

i tried it but it doesnt work

is this some sort of bug of qv10 that the time function doesnt work?

[#3]

what do you mean exactly that it doesn't work? It waits forever? It doesn't wait at all?

[erichshiino]

hi,

Instead of a Windows popup, you can use a QV popup.

Please, check my answer to this post:

http://community.qlik.com/message/119292#119292

hope this helps,

Erich

[#5]

Yep, that works for normal charts but the boxplot charts still don't get pasted on the excel sheet,

still got a white rectangle instead of a boxplot chart even if i wait 50seconds.

Did someone have already been able to export a chart (boxplot) via vb scripting to excel?