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

Set Value of an Input Box via Macro

Hi,

This is probably really simple but I cant get it to work....

I have an input Box  (IB01) which has a variable assigned to it.  This variable is used to cycle through different formats of the page (certain content is viewable depending on the value of the variable).

I want a macro that will input a value in that input box and then I can automate the dump of an excel table from that.  ie. it seems I cant dump an object if its not visible?

The other option is if there is some way to force QV to dump an object that's not visible?

Thanks for your help.

1 Reply
m_woolf
Master II
Master II

ActiveDocument.Variables("YourVariableName").SetContent "YourValue".True