Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a listbox with all ObjectId?

I would like to create a listbox which contains all ObjectId:s.
Then I need to create a macro based on selected objects, for export to Powerpoint or Excel.

How?

/Elisabet

3 Replies
willinek
Partner - Contributor
Partner - Contributor

Hi Elisabet,

you can export the document layout into a XML File. Than you can import this XML File as XML Data and parse out the <ObjectId> Field.

I think in the community you can find some examples of how to export to powerpoint

BR

Alex

Not applicable
Author

OK, thanks, is it also possible to create the listbox in a macro?

Elisabet

willinek
Partner - Contributor
Partner - Contributor

Of course that is possible,

but in generell Macros should be used carefully

set LB = ActiveDocument.Sheets("Main").CreateListBox
set BoxProp=LB.GetProperties
BoxProp.Def.Name = "Customer"
LB.SetProperties BoxProp

for more Details check out the APIguide.qvw in your AQv Installation folder

BR

Alex