topic Macro help! in QlikView

Macro help!

ivan_will — Thu, 28 Apr 2011 22:58:19 GMT

Hi all,

Could anyone explain me why the macro below always plays ding.wav when vMacroUser = David ?

sub PlaySound

If vMacroUser = "David" Then

ActiveDocument.PlaySound "C:\WINDOWS\Media\tada.wav"

Else

ActiveDocument.PlaySound "C:\WINDOWS\Media\ding.wav"

End If

end sub

Thanks!

erichshiino — Thu, 28 Apr 2011 23:07:35 GMT

I don`t think you are evaluating the variable in the right way

Try this:

sub PlaySound

set v = ActiveDocument.Variables("vMacroUser")
if v.GetContent.String = "David"

ActiveDocument ...

for testing purposes you can include a msgbox in the middle for tests: msgbox(v.GetContent.String)

or even msgbox(ActiveDocument.Variables("vMacroUser").GetContent.String)