topic Re: Execute a Macro/Function in Load Script in QlikView

Execute a Macro/Function in Load Script

cmccafferty — Sat, 16 Nov 2024 04:55:33 GMT

I am looking to execute my function (or macro if i was to change it to "sub") inside my load script, so that the tables i have chosen will be downloaded in excel format when the script runs.

The function works fine if I execute it as normal, but would like this to create excel tables as part of the build so that I can use VBA on some excel reports i have so that they get updated based on the downloaded file in the directory.

I have attached a couple of screenshots to show what i have.

Re: Execute a Macro/Function in Load Script

Gysbert_Wassenaar — Thu, 20 Dec 2018 14:31:28 GMT

What do you mean with 'part of the build'?

Re: Execute a Macro/Function in Load Script

cmccafferty — Fri, 21 Dec 2018 08:04:35 GMT

Sorry, by that I meant when the overnight reload occurs, updating the QVW.

Re: Execute a Macro/Function in Load Script

Gysbert_Wassenaar — Fri, 21 Dec 2018 08:17:49 GMT

As I understand it you can't use a macro in the script when you reload your document with Qlikview Server: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/UsingMacrosonQVS.htm