Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
is it possible to acces the content of hidden tab in macro pragmatically?
Saurabh
yes, what are you trying to implement?
I have to change the content of my hidden script for each user who access it.
Can you please tell me how we can access the hidden script?
Is it hidden tab or hidden script?
it is hidden script...the thing that we create by going to File->Create Hidden script.
Is hidden tab something else in QB?
I am very new to QV so please excuse me for my ignorance.
But what is difference between Hidden tab and Hidden script?
And can we change hidden script?
Script can't be changed based on the user who logged in.
However, you can access the charts in the hidden tabs (sheets) with macros like export to excel etc.
I just saw that ActiveDocument.DocumentProperties().Script which gives us the whole script but the hidden script as string and we might change it save it back.
So i thought there might be a way to access the hidden script by providing the password.
Hi Ramya,
The only way to access the hidden script is by editing scritp providing the password. Probably you can not do this through a macro.
It's possible to modify and read hidden script using VBScript using the ActiveDocument.GetCovertScript and ActiveDocument.SetCovertScript functions.
Link: https://community.qlik.com/t5/QlikView-Scripting/Managing-Hidden-Script/td-p/1165353
There is some information in the APIGuide but it seems only from 2013 version onwards which I can't find a direct download link (it's available upon install of Qlikview with Manual/Help however I can't re-install Qlikview on my machine)
I've pasted some VBScript for those still interested (it took me a while to find this)