How to call self module via external script (QlickView Automation)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I try call self module in my Document(.qvw) via PowerShell.

Currently this module named "sei_exp_tsv", and saved in my QlickView document.

This module call from "Run macro" action. I want to automate this action.

But I don't know how to call this module...

** module: sei_exp_tsv

sub sei_exp_tsv

tmpPath = ActiveDocument.GetPathName

lastBackSlash = InStrRev( tmpPath , "\" )

vPath = Left( tmpPath , (lastBackSlash - 1) )

vFileName = "sei_data.tsv"

set Obj = ActiveDocument.GetSheetObject("CH14")

obj.Export vPath & "\Export\" & vFileName," "

end sub

** end module

** PowerShell (v4.0)

$Qv = New-Object -ComObject "QlikTech.QlikView"

$QvDoc = $Qv.OpenDoc("C:\QlikView\QvWork\test.qvw")

# I don't know how to call module

# Cann't work bellow

# $QvDoc.Run("sei_exp_tsv")

** end PowerShell

Please give your idea.

Thanks

Naoki

topic How to call self module via external script (QlickView Automation) in QlikView