Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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
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.
Here another possibility: http://community.qlik.com/thread/1960
- Marcus