- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Urgent: Activate Specific Tab - Macro Trigger
Hi everyone,
I would like to assign a macro to a tab. On clicking this tab the macro would open a new qlikview document specified in the path mentioned. Find below
the macro that i am assigning to the tab.
Sub OpenHome
set App=ActiveDocument.GetApplication
App.OpenDoc "Path\Filename.qvw","",""
End Sub
The new document has several tabs. My requirement is to activate a specific tab in that new document. Not sure how this can be done?
Any ideas?
Tkx.
Harsha
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check of the attachement. Once unzipped you would find two files, HomeDoc and TargetDoc. Demonstrated opening TargetDoc from HomeDoc and dynamically activating the sheet.
OpenDoc:
Has a variable which tells which sheet in TargetDoc to open.
Two button set the variable and runs a macro.
Macro reads the variable, opens TargetDoc and activates the sheet specified in the variable.
Hope this demonstrates your requirement.
Regards,
Kiran.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In the second document: Go to Document Properties->Triggers->On Open and add action Layout->Activate Sheet.
If you want to do this dynamically, you can a set variable value in App.OpenDoc and use that to activate sheet.
Hope this helps,
Kiran
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Kiran,
I would like to have it dynamic, Can you please share an example how i can do this in the macro?
Tkx.
Harsha
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check of the attachement. Once unzipped you would find two files, HomeDoc and TargetDoc. Demonstrated opening TargetDoc from HomeDoc and dynamically activating the sheet.
OpenDoc:
Has a variable which tells which sheet in TargetDoc to open.
Two button set the variable and runs a macro.
Macro reads the variable, opens TargetDoc and activates the sheet specified in the variable.
Hope this demonstrates your requirement.
Regards,
Kiran.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Works Perfectly....Thanks a lot Kiran
- Harsha
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It was very helpful for me as well,
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Kiran, I have a question.
Why if you put in mode webview, the macro dont work, please help me.
Regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The ActiveSheet Trigger doesn't work in WebView.
Try using a button instead.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Kiran,
My question is, I want to open Word documents in a OpenFiles.qvw,
and I created a button that when selecting the button open the word document.
What I did was
Actions tab launch add action and I gave the path where the archivo.qvw was stored
😧 \ QlikView \ Production \ Documents \ Transaction \ User.docx
attached print 1.
Everything works fine, but when I publish the Access Point does not worke and I can't open word documents.
Regards,