Macro on gauge

Mon, 25 Nov 2013 11:06:18 GMT

Hi !

I've got 2 questions for everyone of you !

First : I want to get the value of a gauge, where a number is written by a LED. I go through a macro , and I have written this :

set eff_an = ActiveDocument.GetSheetObject("CH102")

But, then, I don't know what kind of getter I can use to put the result of the gauge into a variable. I've tried a GetText, a GetValue(s), but those methods don't exist. What should I write to get it ?

And the next question : where can I find a PDF, or something like this to know the properties of an Object ? Like in VBA, where the autocomplete shows every methods you can use on the type of object you use.

Thanks a lot !

Re: Macro on gauge

Mon, 25 Nov 2013 14:12:24 GMT

I found it by myself, I put the solution here if someone in the future needs an answer

sub test

set eff_an = ActiveDocument.GetSheetObject("CH102")

ActiveDocument.Variables("effectif_an").SetContent (eff_an.GetTableAsText(false)),true

end sub

Your variable needs to be created before.

And if you've got decimals, change the decimal separator to '.' and not ','

topic Re: Macro on gauge in QlikView

Macro on gauge

Re: Macro on gauge