topic Re: Run Macro From Script in QlikView

Run Macro From Script

Wed, 12 Dec 2012 10:08:03 GMT

Hi,

Is it possible to run a function or sub from the script when the document reloads?

We are trying to automatically load data from a web service through Publisher. The function or sub (it doesn't seem to matter which) runs without a problem in the Edit Module and creates an xml file. However, we need to trigger it from the script so that it will run overnight. Unfortunatley as its Publisher an OnPostReload trigger is not an option.

Many thanks for any help.

Re: Run Macro From Script

Gysbert_Wassenaar — Wed, 12 Dec 2012 10:13:06 GMT

You can call vbscript (or javascript) functions from the load script, but not subs. Here's a very simple example.

Re: Run Macro From Script

Wed, 12 Dec 2012 10:29:18 GMT

Thanks Gysbert, thats useful to know. How can I trigger the function from the reload script? I've tried the below, as suggested elsewhere, but with no luck.

let LoadData = MyFunction();

Thanks