topic Re: Difference between Macro Name and Edit Module in QlikView

Difference between Macro Name and Edit Module

Wed, 07 Aug 2013 09:13:59 GMT

Hi,

What is the difference between the macro name and Edit Module in Button Properties please?

I created a macro called test..vbs, then i enter this name in the macro name in the Button Properties. However, it seems when I click on the Button, it is still executing the macro created in the Edit Module. Any advise please?

Thanks very much!

Re: Difference between Macro Name and Edit Module

Wed, 07 Aug 2013 09:21:52 GMT

Hi,

Edit Module - is the Area/Location where we are going to write the Scripts (either VBScript/JScript).

Macro Name - Here we are assigning the "script function name" which needs to be execusted when the button has clicked.

Example:

Under Edit Module, the script is as follows:

Sub ClearVariable()

ActiveDocument.Variables("vTestvariable").SETCONTENT 0,TRUE

End sub

here Macro name is ClearVariable.

I hope you understand now.

Re: Difference between Macro Name and Edit Module

Wed, 07 Aug 2013 09:46:41 GMT

Thanks very much.

So, if my script is saved as C:\Qlikview\Scripts\AutoChart..vbs

How do I enter this is the Macro Name please?

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

eWindow Helpline

ewindow@platts.com<mailto:ewindow@platts.com>

+65 6530.6530 Singapore

+44 20 7176.6333 London

+1 713 655.2222 Houston

Re: Difference between Macro Name and Edit Module

Wed, 07 Aug 2013 10:05:09 GMT

Hi,

When we insert the .vbs file from your location (C:\Qlikview\Scripts\AutoChart..vbs) to "Edit Module" area (Under Edit module, Edit -> Inser file) we can see the funciton names and it's content. So, After this, we can enter the Macro name.

Re: Difference between Macro Name and Edit Module

marcus_sommer — Wed, 07 Aug 2013 11:16:51 GMT

Here another possibility: http://community.qlik.com/thread/1960

- Marcus