Execute a Macro/Function in Load Script

[cmccafferty]

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.

[Gysbert_Wassenaar]

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

[cmccafferty]

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

[Gysbert_Wassenaar]

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