Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
danana
Partner - Contributor
Partner - Contributor

Setting a value for the event "on open" via VB

Hi everyone!

Is there a possibility of setting the "on open" event via VB? I'm using Version 8.5. Version 9 is not an option yet.

Quick explanation:

I created a project that gets data from an SQL Database. I use the publisher to produce different publications according to the users. However there is one field that cannot be reduced by the publisher. If I connect it to the user I will have a circle relationship I've written a VB application that actually opens every Qvw, looks up the needed values of that field, selects them and then reduces the data. It's all fine except the project is multilingual (so far 3 languages) and has a macro on the "on open" event to select a language when opened. Since the other languages are then not selectable they get reduced. My Idea is to set those event macros while I reduced with the VB application.

Nana

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

In 8.5, you can set it with ActiveDocument.GetProperties.OnOpenMacro, but it will break when you go to V9. In V9 this has been replaced by Actions and my understanding is that there will be no API access for Actions.

-Rob

danana
Partner - Contributor
Partner - Contributor
Author

Rob,

Thank you very much! I had over seen that function.

Nana