topic Re: Macro Issues in QlikView

Macro Issues

ajithsachin — Wed, 04 Sep 2013 06:04:48 GMT

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 — Wed, 04 Sep 2013 06:09:15 GMT

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 — Wed, 04 Sep 2013 06:48:07 GMT

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 — Wed, 04 Sep 2013 07:03:35 GMT

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