VBA to run Query Designer

I want to run my existing Query I wrote using Essbase Query Designer, in Excel using VBA. But all it does is open the Query Designer wizard for me, but doesn't wait for my response and proceeds to the next step. What should I do?
Currently I have:

 qmenu = EssMenuVQueryDesigner()
If qmenu = 0 Then
MsgBox ("query successful!")
Else
MsgBox ("Try again!")
End If

And I get "Try again" message box.

Any help to make this process simple is appreciated! Basically I want to open already saved Query and run that before retrieving data. So maybe I don't even have to use EssMenuVQueryDesigner() function...

Thanks!