topic Re: Error in Macro in QlikView

Error in Macro

rphpacheco — Fri, 28 Jun 2013 14:21:13 GMT

Hello All!

I have a macro in a document and accessing it via the Access Point displays the following error:

"Analysis of macro failed. Functionality was lost

Robo_Refresh

Error: ActiveX component can not create object: 'WScript.Shell' "

Sub Robo_Refresh


       Set WshShell = CreateObject("WScript.Shell")
       RegKey = "HKEY_LOCAL_MACHINE\SOFTWARE\Cassol\StatusCargaCadeiaValores"

       if WshShell.RegRead(RegKey) = "CARREGOU" Then
             WshShell.RegWrite RegKey, "ATUALIZOU", "REG_SZ"

           LimparSelecoes()
           SetarData()

      End If

End Sub

What is going wrong?

Re: Error in Macro

rphpacheco — Thu, 11 Jul 2013 15:42:36 GMT

Any suggestions to the problem?

Thanks.

Re: Error in Macro

Anonymous — Thu, 11 Jul 2013 15:53:21 GMT

Raphael, make sure you allow "system acess" to the macro.

Re: Error in Macro

rphpacheco — Thu, 11 Jul 2013 16:03:27 GMT

Yes Michael, the access permissions for the macro already enabled. Yet the problem occurred.

Re: Error in Macro

Anonymous — Thu, 11 Jul 2013 16:11:40 GMT

It is in multiple places: in macro module (left bottom, two palces), and user allows all macro (either on macro security dialog or user preferences - security, the top checkbox)