Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I access a variable's predefined list through a macro?

Greetings.

I have variables with predefined lists. I would like to use that list in a macro, and I have no idea how to access it. I can see PreDefinedList as a property, and there is an example on how to set it, but I have no idea how to pull the data from it.

Help?

Thanks.

Labels (1)
1 Solution

Accepted Solutions
Not applicable
Author

Hi,

try something like this:

set v = ActiveDocument.Variables("Variable1")

prop = v.GetProperties

dim list2

list2 = prop.PreDefinedList

msgbox(list2(0))



Regards!

View solution in original post

2 Replies
Not applicable
Author

Hi,

try something like this:

set v = ActiveDocument.Variables("Variable1")

prop = v.GetProperties

dim list2

list2 = prop.PreDefinedList

msgbox(list2(0))



Regards!

Not applicable
Author

My vb is terrible - I knew I was missing something straightforward.. That's exactly what I needed! Thanks.