Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.

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.