Qlikview Macro - Gives Error -while running through Windows Scheduler

[#1]

Hi,

I have written a macro in Qlikview, which export 3 different reports, Combine those 3 workbooks into 1, also renaming the excel sheets in that workbook. I created batch file, throuh which i am passing the value for a variable. Based on the value of the variable the macro will execute. While running the Batchfile manually the macro works fine. But, the same batchfile through windows scheduler not working.

While running through Windows scheduler even i tried with ON ERROR RESUME NEXT, then it omits the renaming and combining the workbook, simply exports the reports into excel.

My observation is while running through scheduler it not supports to create object for "Excel.Application" and other stuff.

Can you guys help me to come out of this issue.

Regards,

Yoga

[#2 · Accepted solution]

Created the Task in Scheduler with the Admin User after that it works well.