executing VB macro in script

[#1]

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??

[Anonymous]

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

[#3]

Hi Konstantins,

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

[vikasmahajan]

On-Post Reload you can execute the same.

Vikas

[jagan]

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.

[#6]

Hi Vikas,

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

[Anonymous]

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

[Anonymous]

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

[#9]

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??

[Anonymous]

Look my notes I've added recently

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