Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
Is there a way to identify which version of Internet Explorer the client is using. I know some clients are using IE6 and i want to run a macro onopen to prompt them to upgrade their browser?
I am running QlikView 9.
Any help would be great.
Robbie
Hi Robbie,
If using the Plug-in, you can use the following to read the registry* ...
Sub GetIEVersion
Dim Temp, objRegistry, Key
Set objRegistry = CreateObject("Wscript.shell")
Key = objRegistry.RegRead("HKEY_LOCAL_MACHINE\Software\Microsoft\Internet Explorer\Version")
set t = activedocument.getsheetobject("TX01") 'set the text value of TX01 with the key
p = t.GetProperties
p.layout.text.v = Key
t.setproperties p
End Sub
... but if you run this in AJAX you will get the key value from the server!!! It's also possible that users have already changed this value for other reasons and is therefore not 100% reliable.
The Client Type IS stored in the Session logs, but not sure if this can be accessed until the session ends.
flipside
* Usual disclaimer for anyone accessing the registry - ensure you know what you are doing before changing any values in the registry as it could cause major system problems!!! Back up your registry first.
*BUMP*
*BUMP*
Hi Robbie,
If using the Plug-in, you can use the following to read the registry* ...
Sub GetIEVersion
Dim Temp, objRegistry, Key
Set objRegistry = CreateObject("Wscript.shell")
Key = objRegistry.RegRead("HKEY_LOCAL_MACHINE\Software\Microsoft\Internet Explorer\Version")
set t = activedocument.getsheetobject("TX01") 'set the text value of TX01 with the key
p = t.GetProperties
p.layout.text.v = Key
t.setproperties p
End Sub
... but if you run this in AJAX you will get the key value from the server!!! It's also possible that users have already changed this value for other reasons and is therefore not 100% reliable.
The Client Type IS stored in the Session logs, but not sure if this can be accessed until the session ends.
flipside
* Usual disclaimer for anyone accessing the registry - ensure you know what you are doing before changing any values in the registry as it could cause major system problems!!! Back up your registry first.
You sir are a genius!!
I am using the Plug-In so all is good.
To anyone wishing to use this don't forget in 'Edit Module' 'Current Local Security' must be set to 'Allow System Access'.
Cheers flipside.