Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to use three similar (but different) macros within my QVW. In each macro only the highlighted portion would differ. The challenge I face is, if I modify the code in one place, the same modification gets reflected across the QVW in all other macro codes. How to modify the below code without affecting a similar code elsewhere in the QVW. FYI: I am calling these macros within a Button action.
Thanks,
Sudha.
Make shure your QV variable has a string (text) value, you can try converting the pseudoParam1 to string.
Maybe this line is usefull, replace the line that throws the error with the following:
'this will let you know the value of the variable
msgbox pseudoParam1
'converting the value to a string befose passing it
set obj = ActiveDocument.GetSheetObject(cstr(pseudoParam1))
Let me know if it works.
Regards,
Maybe I didn't make myself very clear. Obviously you are still trying with only one sub-routine.
Create three - 3 separate Sub-routines and then create separate Buttons that point to each one - each with a different name. Then you will avoid your problem.
Here is an attached Application that proves that it should work if it is done like I described.
Sounds like you are using Linked Objects for the buttons. Right Click each button, an select "UnLink".
-Rob
Hi,
Could you please tell me how to unlink the buttons. When I right click the button, I don't see any option related to link/unlink. I am using Qlikview 11.2 SR6.
Thanks,
Sudha
Using three different subroutines solved the issue. Thanks!!