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

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

Fri, 14 Nov 2014 12:35:14 GMT

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 ?

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

giakoum — Fri, 14 Nov 2014 12:37:33 GMT

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

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

Brett_Bleess — Fri, 14 Nov 2014 12:41:25 GMT

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

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

Fri, 14 Nov 2014 13:56:49 GMT

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

Regards