topic Export excel through macro from Win Task Schedular in QlikView

Export excel through macro from Win Task Schedular

Sat, 30 Jan 2016 11:17:49 GMT

Hello Friends,

I have on app and i am using two excel macro to export straight chart data from qlikview file but i dont have the server i am using the windows task scheduler for app reload and export excel from macro by this qlikview file how can i achieve this.

Desouza

Re: Export excel through macro from Win Task Schedular

HirisH_V7 — Sat, 30 Jan 2016 20:44:09 GMT

Hi,

Like this,

Go to -> Document Properties in your App -> Triggers tab-> Document Event Triggers -> on post reload run your macro -> Save.

Then Create a batch file as per your App location .Then run and check that your export is working or not.

Now you can create a Job in your Task Scheduler as In attachment.

HTH,

PFA,

Hirish

Re: Export excel through macro from Win Task Schedular

Mon, 01 Feb 2016 07:27:26 GMT

I have to use /R or /L for macros because i triggered macros by this application and generate excel file and why this /R and /L is used

"C:\Program Files\QlikView\QV.EXE" /R "Location\Your App .qvw"

"C:\Program Files\QlikView\QV.EXE" /L "Location\Your App .qvw"

Thanks

Re: Export excel through macro from Win Task Schedular

HirisH_V7 — Mon, 01 Feb 2016 11:21:55 GMT

Hi,

The /l switch (that's a lower case ell) will open the report, run the reload function and leave the report open.

HTH,

Hirish