Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
I have a QV dashboard with 10 different users, I need to know who is actually using the dashboard and when ( Its an internal debate issue !!)
Our support have told me that there is no easy way to record this so I was thinking that ( AND I DONT KNOW IF THIS IS POSSBLE)
as a work around --
Hide all sheets - bar one
On this sheet put a button that when toggled
shows all sheets and
*Presumably uses a macro to update an Excel file on the s drive with data based on users info
-- Hence I would have a log of all users!!!
Has anyone got any feedback on this ?
Do you think its possible?
Should I not even try and persue it ?
Any advice greatly appreciated
Thanks
A
I'm trying again.
The admin will log into the PC and run this vbscript.
Copy the script and paste into a text editor.
Change cSERVER_NAME to your server name.
Save with any name and a .vbs extension.
'// **************************************************
'// Script for adding some registry keys to the current user profile/registry settings
'// for enabling the macro security/module security for the SERVER defined below
'// ~
'// CONFIGURATION
'// Just configure the script by defining your server below
'// ~
'// The article explaining this script can be found at
'// qlikblog.at/523 ' put www. in front
'// **************************************************
CONST cSERVER_NAME = "YOUR_SERVER_NAME"
Dim WshShell 'as Object
' Delete any registry entries where the user blocked script for the server
on error resume next
WSHShell.RegDelete "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script Blocked\" & cSERVER_NAME
WSHShell.RegDelete "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script Blocked\"
Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\", 1, "REG_SZ"
WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script System\", 1, "REG_SZ"
WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script System\ " & cSERVER_NAME, "", "REG_SZ"
I tried again without success.
See if you can read this blog: