macro on browser

Thu, 06 Dec 2012 10:01:15 GMT

We are trying to log users that opens documents and we are using triggers "onOpen" trigger to call LogLogin Sub

however , client based qlikview also open in server runs this macro, but access point ( from web browser ) not working .

Also we tried to run this macro with button , same result..

Any Idea ?

Public Sub LogLogin

on error resume next

Dim DocName

Dim UserName

DocName=ActiveDocument.Name

set temp = ActiveDocument.GetApplication.GetProperties

UserName=temp.UserName

Dim mConnection

Set mConnection = CreateObject("ADODB.Connection")

mConnection.Open "xxxxxxxxxxxxx","xxxxxxxxxxx","xxxxxxxxxxxxxx"

Dim sql

sql="INSERT INTO xxxxxxxx (UserName,DocumentName) values ('" & UserName & "','" & DocName & "')"

mConnection.Execute sql

mConnection.close

Set mConnection = Nothing

if Err<>0 then

msgbox err

end if

end Sub

topic macro on browser in QlikView