Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

gjamila_esq
Not applicable

Reload EDX macro and OCX error

Hi all,

  I would like to run a qlikview task from access point via EDX.

So i write this macro

Sub ReloadDWH

  dim strCommand

  strCommand= ActiveDocument.Variables("vEDX_GMBI").GetContent.String

  msgbox(strCommand)

  Set WshShell = CreateObject("WScript.Shell")

  msgbox("set wshell")

  Return = WshShell.Run (strCommand,0,false)

  msgbox("Comando eseguito attendere ricaricamento")

End Sub 'ReloadDWH

I have a button with run macro action.

With QlikView local client it works, but in the access point I have this error:

"Macro Parse Failed. Functionality was lost. Error:"

Cattura.PNG

Trigger:

Cattura2.PNG

Variable:

"D:\QMSEDX\QMSEDX.exe" -task="GMBI_DWH_LIV2.QVW" -verbosity="5"

I also tryied this:

"\\machinename\d$\Program Files\QMSEDX\qmsedx.exe" -task="GMBI_DWH_LIV2.QVW" -qms=http://localhost:4799/QMS/Service -password=""

Any ideas?
Thank you so much!