Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted
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
Highlighted
Contributor III
Contributor III

Re: Execute a Macro/Function in Load Script

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

Highlighted
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