topic Re: Automatically daily export to excel in QlikView

Automatically daily export to excel

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I've written a macro in qlikview in order to export to excel.

Now How could I automatically export to excel and not manually execute the macro ?

PrashantSangle — Tue, 26 Apr 2016 12:32:24 GMT

Hi,

Check NPrinting tool

Regards

amit_saini — Tue, 26 Apr 2016 12:38:20 GMT

Hi,

I believe without macro not possible and yes as suggested by max , for these kinds of requirements "N-Printing" is the best option.

Thanks,

ajaykumar1 — Tue, 26 Apr 2016 12:40:33 GMT

Hi,

If in case your macro code working properly; to automate this process we need to follow below steps.

1. Need to create the batch file like ;

"C:\Program Files\QlikView\Qv.exe" NoSecurity "F:\XXXXX.qvw"

2. create the windows schedular task by calling the above created batch file.

I hope it will work.

Regards,

Ajay

avinashelite — Tue, 26 Apr 2016 12:41:23 GMT

I would suggest to go with the NPrinting tool , check this thread for the complete information

trdandamudi — Tue, 26 Apr 2016 13:07:58 GMT

Create a batch file and then use windows scheduler to run it automatically.