Run a Macro every 5 seconds

[hmjason7]

Hi All,

I have a macro that I would like to run every 5 seconds. What is the best way of doing this?

The macro basically selects every possible value for a given field. So if I have a button with the macro "Test" as an action, every time I click on it, the field "Field" will select a different value each time.

But naturally I don't want to have to keep clicking on this every 5 seconds. How can I automate this process, i.e. have this macro run every 5 seconds in the background?

Sub Test

ActiveDocument.getField("Field").select ActiveDocument.Evaluate("minstring({1}if(Field>'$(=Field)',Field))")

end Sub

Cheers,

Jason

[agni_gold]

Are you using Qlikview server ?

[hmjason7]

No, currently I am just demoing this on the desktop.

[agni_gold]

So without server you cannot do this ,

Do one thingh , create a button and add the action on it to run the macro  (But it is a manual process user have to click on the button )