Macro Issues

[ajithsachin]

Hi All,

     I have a macro that will export a chart as a image to a specific location and that image i am attaching as a email

     body and sending.This script is working fine when i am doing the reload manually.

     And i have wrote a external vb script that will open and reload the qvw application.That time also it is exporting the chart

     to the location but after that not sending the mail.

     My External VB Script Below i am mentioning:

     '=======================================================================================

     Set MyApp = CreateObject("QlikTech.QlikView")

     Set MyDoc = MyApp.OpenDoc ("D:\QlikView_Working_Folder\CSquareTopGear\Export Dashboard.qvw","","")

     Set ActiveDocument = MyDoc

     ActiveDocument.Reload

     'ActiveDocument.GetSheetObject("TX142").click

     ActiveDocument.Save

     Set MyDoc = Nothing

     MyApp.Quit

     Set MyApp = Nothing

     '=======================================================================================

     Can anybody help please.

Regards,

Ajith

[vikasmahajan]

Open your QVW  Select Edit Module

Check  Requested Module Sccurity -> System Access

Check Current System Access -> Allow System Access

Hope this will resolve you issue

Vikas

[ajithsachin]

Thanks Vikas,

i didn't check that.

Now i have made that as a batch file with /l command.

I f i am double clicking the batch file application is getting reload and send the mail. but when i am running that

batch file through Windows task scheduler the status is showing 'Running' but the qlikview application is not

opening or reloading even the mail is also not getting.

Is there any settings i have missed or user related issue..?    

[vikasmahajan]

Hii

Please refer screen short for scheduling jobs and task in windows server ,

I have same problem , But resolved by clicking advance tab while creating task you need to select advance tab

and Change User or Groups tab -> Select -> Advanced -> Select -> Administratorss group

Please note it will not show you any thing only log file will be generated when schedular runs.

Hope this help you

Vikas