topic Re: VB script in QlikView

VB script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have run VBscript using macros. But my requirement is to run the VBscript automatically when I reload my QVW file. Can any one tell how it can be done ??

Re: VB script

stabben23 — Fri, 21 Apr 2017 06:58:42 GMT

Hi,

how do you reload Your QVW? is it a manual reload in desktop or is it a task in QMC?

Re: VB script

prachisangewar — Fri, 21 Apr 2017 07:07:59 GMT

hi,

On the QMC, go to System Tab -> Setup -> Security

Click on the "Allow macro execution on the server" check box.

Re: VB script

petter — Fri, 21 Apr 2017 08:10:51 GMT

Pure VBScript functions can be called from a load script if they don't try to reference the QlikView Object Model.

The load script phase that a reload is does not have a UI to operate on. The only thing that is accessible is the tables, fields and variables during the reload and running of the load script. No manipulation of the UI can or will occur during this phase.

Macro execution on the server will occur only when a QlikView application has been started by a user. This is occurs after and not immediately after an application has been reloaded.