Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Automated excel creation failed while loading through QMC.

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?

1 Solution

Accepted Solutions
vikasmahajan
Honored Contributor III

Re: Automated excel creation failed while loading through QMC.

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

Vikas

15 Replies
gainkarthi
Valued Contributor

Re: Automated excel creation failed while loading through QMC.

Do your server has excel installed.?

jerrysvensson
Valued Contributor II

Re: Automated excel creation failed while loading through QMC.

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

Not applicable

Re: Automated excel creation failed while loading through QMC.

yes excel is installed on the server

Not applicable

Re: Automated excel creation failed while loading through QMC.

i scheduled through QMC.

Not applicable

Re: Automated excel creation failed while loading through QMC.

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

vikasmahajan
Honored Contributor III

Re: Automated excel creation failed while loading through QMC.

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

Vikas

vikasmahajan
Honored Contributor III

Re: Automated excel creation failed while loading through QMC.

See attached screen short for the same.

Hope this will solve your problem.

Vikas

Not applicable

Re: Automated excel creation failed while loading through QMC.

Hi Vikas,

Thanks for help.

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

vikasmahajan
Honored Contributor III

Re: Automated excel creation failed while loading through QMC.

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

Thanks

Vikas

Community Browser