Running macro function in the loading script

dradoikov — Wed, 05 Jul 2017 07:13:52 GMT

Hello,

I have got the following problem: I want to export tables from the loading script and I am using macro function in the module:

function Export()

set qv = CreateObject("QlikTech.QlikView")

set doc = qv.OpenDoc("C:\Users\username\Desktop\ARP.qvw")

set chart = doc.GetSheetObject("CH09")

chart.Export "D:\Data.txt", ", "

'doc.CloseDoc

'qv.Quit

end function

I cannot call it from the loading script.

Any advice is welcome.

Regards,

Daniel

Re: Running macro function in the loading script

marcus_sommer — Wed, 05 Jul 2017 13:02:46 GMT

It's not possible on this way. You will need to do it from outside of a load, see also: Macro running through load script or you could use a store-statement to an existing table to get the txt-file.

- Marcus

topic Re: Running macro function in the loading script in QlikView

Running macro function in the loading script

Re: Running macro function in the loading script