Solved: Automated excel creation failed while loading thro... - Qlik Community

Report Inappropriate Content · ‎2013-06-24

Hi All,

Automated excel creation failed while reloading through QMC,

when i manualy loaded the QVW the excel file is created and updated.

I want at the time QMC relaods the QVW excel file also gets updated.

so i use document properties->triggers->after post relaod->macro which creates the excel file.

But is is not working with QMC when i manualy reload qvw it is working and excel file is updated.

Is it so that through QMC the macro is not enable?

vikasmahajan · ‎2013-06-27

One Way You can create jobs through windows schedular and execute it.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

gainkarthi · ‎2013-06-26

Do your server has excel installed.?

jerrysvensson · ‎2013-06-26

After-post-reload macros will not run when reloading with publisher.

Report Inappropriate Content · ‎2013-06-27

yes excel is installed on the server

Report Inappropriate Content · ‎2013-06-27

i scheduled through QMC.

Report Inappropriate Content · ‎2013-06-27

What will be the work around for this?Please suggest.

vikasmahajan · ‎2013-06-27

One Way You can create jobs through windows schedular and execute it.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2013-06-27

See attached screen short for the same.

Hope this will solve your problem.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-06-28

Hi Vikas,

Thanks for help.

Could u please tell me what is there in the macro.bat?

vikasmahajan · ‎2013-06-30

Reuqest you mark for helpful or correct ans if you are satisfy with ans

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Automated excel creation failed while loading through QMC.