Export excel through macro from Win Task Schedular

[#1]

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

[HirisH_V7]

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

[#3]

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

[HirisH_V7]

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