Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
cmccafferty
New Contributor II

Execute a Macro/Function in Load Script

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.

Labels (3)
3 Replies
MVP & Luminary
MVP & Luminary

Re: Execute a Macro/Function in Load Script

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

talk is cheap, supply exceeds demand
cmccafferty
New Contributor II

Re: Execute a Macro/Function in Load Script

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

MVP & Luminary
MVP & Luminary

Re: Execute a Macro/Function in Load Script

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


talk is cheap, supply exceeds demand