How to run the macros automatically ?

[Anonymous]

Hi to all Community peoples,

I have a doubt regarding qlikview macros .

I'm created a macro code to export the data to excel and stored the excel file in my machine,

I'm doing this manually by every day,

I want to run the MACRO(Macro Name is Export_To_Excel) automatically in every day for particular time is it possible ??

Thanks in advance.....

[alexandros17]

Yes it is, you have to use a postreload event (trigger) but ... unfortunately this trigger and macros do not work togheter so you need a batch (scheduled by window) that launch the document

[ashfaq_haseeb]

Hi,

You can try with windows scheduler.

Regards

ASHFAQ

[Anonymous]

Hi Alessandro,

Thanks for u r quick reply ..

I didn't understand the solution what u said..

Can u please share if possible a sample document or sample application ???

Thanks in advance...

[Anonymous]

Hi Ashfaq,

I known as from windows scheduler we can reload the entire qlikview application, I think so we are not able to run the particular MACRO in the qlikview application, If possible with windows scheduler please give me in detail..

Thanks in Advance....

[alexandros17 · Accepted solution]

Unfortunately I have not a sample document, here there are the step to create one:

1) in the document menu: Settings -> Document Properties -> Trigger -> onPostReload -> Add -> external -> Run Macro write the name of your macro (the one that export data)

2) in the task scheduler (in windows) you have to define a new task that runs a batch file like the following one:

"C:\Program Files\QlikView\Qv.exe" /r "E:\QlikSource\Sales\MyDocumentName.qvw" >> E:\myDirectory\MyDocumentName.log

[Anonymous]

Hi Alessandro,

Thanks for u quick reply....

This is very helpful and resolved my doubt also .....

Thanks a lot ........