macro on browser

[#1]

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