How do I run a QV application in QMC from an Excel VBA macro ?

[#1]

Hi Everyone, 

I have a QV application scheduled in my Management Console. Is it possible to run the application via a button on an Excel worksheet using VBA code ?

I have a reasonable knowledge of VBA but can't think how I would communicate with the QV scheduler externally.

Any ideas ?

MV

[giakoum]

the cmd command is as follows :

EXECUTE cmd.exe /C "C:\Qlikview\QMSEDX.exe -task="Same task" -qms=http://someserverIP:4799/QMS/Service -password=999 -verbosity=3";

Adjust it to your needs

[Brett_Bleess · Accepted solution]

Maureen,

Check out the following two links, the first is a basic example and the latter is a more advanced one, but these utilize the EDX trigger, which should do the trick.  Just note that any user launching this must be in the QlikView EDX local security group on the QVServer, which you will have to create.  This is documented in the QlikView Server Reference Manual in Chapter 26.  I hope this gets you on the right track.

Regards,

Brett

Basic link:

Using EDX in QlikView 11 - basic example

Advanced link:

Using EDX in QlikView 11

[#4]

Thanks Brett. That's a great place to start. Lots of reading and practice needed I think.

Regards

MV