Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

VB script

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 ??

3 Replies
stabben23
Partner - Master
Partner - Master

Hi,

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

prachisangewar
Creator
Creator

hi,

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

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

Macro.png

petter
Partner - Champion III
Partner - Champion III

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.