topic Re: Automated excel creation failed while loading through QMC. in QlikView

Automated excel creation failed while loading through QMC.

Mon, 26 Jan 2026 18:19:17 GMT

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?

Re: Automated excel creation failed while loading through QMC.

gainkarthi — Wed, 26 Jun 2013 09:37:07 GMT

Do your server has excel installed.?

Re: Automated excel creation failed while loading through QMC.

jerrysvensson — Wed, 26 Jun 2013 09:49:57 GMT

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

Re: Automated excel creation failed while loading through QMC.

Thu, 27 Jun 2013 05:11:03 GMT

yes excel is installed on the server

Re: Automated excel creation failed while loading through QMC.

Thu, 27 Jun 2013 05:11:51 GMT

i scheduled through QMC.

Re: Automated excel creation failed while loading through QMC.

Thu, 27 Jun 2013 05:12:31 GMT

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

Re: Automated excel creation failed while loading through QMC.

vikasmahajan — Thu, 27 Jun 2013 05:20:28 GMT

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

Vikas

Re: Automated excel creation failed while loading through QMC.

vikasmahajan — Thu, 27 Jun 2013 05:21:35 GMT

See attached screen short for the same.

Hope this will solve your problem.

Vikas

Re: Automated excel creation failed while loading through QMC.

Fri, 28 Jun 2013 13:55:27 GMT

Hi Vikas,

Thanks for help.

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

Re: Automated excel creation failed while loading through QMC.

vikasmahajan — Mon, 01 Jul 2013 03:33:51 GMT

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

Thanks

Vikas

Re: Automated excel creation failed while loading through QMC.

Mon, 01 Jul 2013 05:47:28 GMT

Could u please share screenshot of macro.bat file..

Re: Automated excel creation failed while loading through QMC.

vikasmahajan — Fri, 19 Jul 2013 10:03:04 GMT

Batch File

"C:\Program Files\QlikView\qv.exe" /l /noSecurity "D:\Qlikview Applications\Email_Distribution.qvw"

EXIT

Re: Automated excel creation failed while loading through QMC.

Mon, 26 Aug 2013 08:14:44 GMT

Hi Vikas,

Thanks Vikas,

Yes through Task scheduler the excel is created automaticaly,but now i am facing another issue.

The excel which is created is having different date columns with different format .

For Eg:-

Cust Name Service Customer Order Date Order Delivery Date Order Completion Date
ABC An68235 19-Jul-2013 9:40:12 21-Jul-2013 8:50:12 07/30/2013

DEF Def23234 09-Apr-2012 9:40:12 19-Apr-2012 10:40:12 04/25/2012

The "Customer Order Date " and "Order Delivery Date" is having the DD-MMM-YYYY hh:mm:ss format

and "Order Completion Date" is having MM/DD/YYYY format.

when i use macro then in excel these dates are in format YYYY/MM/DD hh:mm:ss.

Please help me in this.

Re: Automated excel creation failed while loading through QMC.

vikasmahajan — Mon, 26 Aug 2013 09:11:38 GMT

Hii,

You can fix date format in qlikview main tab using following command

SET DateFormat='DD/MM/YYYY';

So that you can set all date formats as std.

Hope this help you.

Vikas

Re: Automated excel creation failed while loading through QMC.

Wed, 11 Sep 2013 14:19:45 GMT

Hi Vikas,

Again facing one issue ,previously i created task in task scheduler by having the setting that 'When the user is logged on' and in security options it is defined as to use my account but i m not administrator.

When i use the option 'Run whether user is logged on or not'
the task fails as i logged off from the server.

The screenshot which u attached in that u used the option in security options ' Run whether user is logged on or not'

.but when i used my task runs succesfully but the excel is not generated.

Plaese me in this.

Re: Re: Automated excel creation failed while loading through QMC.

vikasmahajan — Thu, 12 Sep 2013 04:03:49 GMT

Click on General Tab -> Select Change Users or Groups tab -> Click on Advanced Tab -> Search for Administratorss -> After selecting this windows scheduler will works no issue , Here I have no problems with this setting.

I am attaching screens for setting.

Good Luck.

Vikas