Monday, 15 June 2015

SendKeys does not work for a particular key combination in QlikView 11 -



SendKeys does not work for a particular key combination in QlikView 11 -

as can see in script below, trying utilize sendkeys send ctrl+shift+s show sheets , objects in qlikview, not work. however, if send other keys "^s" (ctrl+s) works fine.

set objshell = createobject("wscript.shell") set qv = createobject("qliktech.qlikview") qv.opendoc "c:\program files\qlikview\examples\documents\executive dashboard.qvw" set qvdoc = qv.activedocument wscript.sleep 1000 objshell.appactivate qvdoc.getapplication.getprocessid objshell.sendkeys "^+s"

in particular case, "show sheets , objects" alternative (which triggered hidden key combination ctrl+shift+s) user privilege , forms part of overall document security, whereas save not user privilege.

as document security important, believe qliktech disabled write access setting. means read via com. may not appear clear why of should impact you, however, passing key combinations. however, instantiating qlikview via com, believe qlikview application detects , hence automatically disables key combinations alter user permissions document.

an alternative cause of qlikview document running in user mode rather admin mode , such disallow changing of user privileges, perhaps worth check section access on document.

an alternative command visibility of hidden sheets status points variable, , alter variable show hidden sheets windows script. farther reading on solution , other give-and-take may found here: http://community.qlik.com/thread/36719#155925

qlikview

No comments:

Post a Comment