topic Re: executing VB macro in script in QlikView

executing VB macro in script

Mon, 15 Sep 2014 12:05:48 GMT

Hello all,

I have craeted the macro

Sub SMS

set obj=ActiveDocument.GetSheetObject("CH1736")

obj.ExportEx "E:\ADW_Trigger\QlikviewSMS.txt",1

End Sub

Can anyone tell me how do i execute this in script?? So that desire output i.e a text file will be created in ADW_Trigger folder as mention in macro??

Re: executing VB macro in script

Anonymous — Mon, 15 Sep 2014 12:14:40 GMT

Hi,

You need link your macro with any of Actions->External->Run Macro or Triggers->Actions...

Put button to the sheet, ope properties, go to Actions -> Add External -> Run Macro and put SMS tot he Macro Name field

Re: executing VB macro in script

Tue, 16 Sep 2014 05:14:02 GMT

Hi Konstantins,

i want with the execution of script Macro gets executed automatically not by adding button

Re: executing VB macro in script

vikasmahajan — Tue, 16 Sep 2014 05:21:02 GMT

On-Post Reload you can execute the same.

Vikas

Re: executing VB macro in script

jagan — Tue, 16 Sep 2014 05:44:07 GMT

Hi Rohit,

You can call macro by using

Button -> Actions -> Add -> External -> Run Macro and put SMS

or you can call this while reloading the document like this

Settings -> Document Properties -> Triggers -> Document Event Triggers -> OnPostReload -> Edit Actions ->Add -> External -> Run Macro and put SMS

Regards,

Jagan.

Re: executing VB macro in script

Tue, 16 Sep 2014 06:03:48 GMT

Hi Vikas,

Tried it executing on post reload but txt file is not getting created in the folder

Re: executing VB macro in script

Anonymous — Tue, 16 Sep 2014 06:08:20 GMT

One thing - On-Post reload trigger works with desktop application, but not under AccessPoint

Re: executing VB macro in script

Anonymous — Tue, 16 Sep 2014 06:09:50 GMT

What does it mean automatically? after the reload apps? or when you activate chart object in the sheet?

Re: executing VB macro in script

Tue, 16 Sep 2014 06:10:03 GMT

Hi Jagan,

I have scheduled application on publisher but post reload on macro ain't working , file is not getting created in folder,couldnot figure out why macro is not getting executed? is this because i scheduled it on publisher ? and ain't there any way to write some commands in qlikview script in backend , so when application gets reload Macro will be executed too??

Re: executing VB macro in script

Anonymous — Tue, 16 Sep 2014 06:12:45 GMT

Look my notes I've added recently

>>One thing - On-Post reload trigger works with desktop application, but not under AccessPoint

Re: executing VB macro in script

Tue, 16 Sep 2014 06:18:34 GMT

Re: executing VB macro in script

jagan — Tue, 16 Sep 2014 06:20:27 GMT

Hi,

Add this two commands at the end of the macro

ActiveDocument.Save

ActiveDocument.GetApplication.Quit

Hope this helps.

Regards,

jagan.

Re: executing VB macro in script

Anonymous — Tue, 16 Sep 2014 06:29:18 GMT

In the publisher you can create Supporting task and add trigger for the task after the app reloading/distribution.

In the command line statement you need to put your macro script execution via batch file(just transfer function from module to vbs file)

batch file example:

cscript "C:\SMS.vbs"

VBS:

Sub SMS

set obj=ActiveDocument.GetSheetObject("CH1736")

obj.ExportEx "E:\ADW_Trigger\QlikviewSMS.txt",1

End Sub

Re: executing VB macro in script

Tue, 16 Sep 2014 09:44:48 GMT

Hi,

I added both

ActiveDocument.Save

ActiveDocument.GetApplication.Quit

at the end of macro and ran it through publisher but file is not getting created in folder, if i dont run it through publisher it works ,couldnot find out the reason??

Re: executing VB macro in script

Tue, 16 Sep 2014 09:46:36 GMT

Hi,

I added both

ActiveDocument.Save

ActiveDocument.GetApplication.Quit

at the end of macro and ran it through publisher but file is not getting created in folder, if i dont run it through publisher it works ,couldnot find out the reason??

Re: executing VB macro in script

jagan — Tue, 16 Sep 2014 10:10:19 GMT

Hi Rohit,

Try using the Windows scheduler instead of Qlikview publisher.

Regards,

Jagan.