topic Ending Qlikview in a Macro in QlikView

Ending Qlikview in a Macro

Tue, 20 Oct 2009 04:42:40 GMT

Want to exit from Qlikview when my macro finishes; How is this done?

Ending Qlikview in a Macro

Tue, 20 Oct 2009 04:49:48 GMT

Try this, bye

ActiveDocument.GetApplication.Quit

Ending Qlikview in a Macro

Tue, 20 Oct 2009 05:03:48 GMT

Thank you!

Ending Qlikview in a Macro

Tue, 20 Oct 2009 05:26:48 GMT

Problem: My macro runs when the doc opens so,

placing ActiveDocument.GetApplication.Quit at the bottom of the macro does exactly what I want

But, SINCE Qlikview ends after the macro runs I am LOCKED OUT OF THE DOC > CAN'T get in and

MAKE CHANGES! Any way to step thru perhaps, with a debug routine? (I have the demo personal edition).

Ending Qlikview in a Macro

Anonymous — Tue, 20 Oct 2009 10:14:40 GMT

The first time you open a document with macros you should get a question as to what security level you want to give the document.

This information is stored in the registry under three different keys:

HKEY_CURRENT_USER\Software\QlikTech\QlikView\Module Checksums Blocked

HKEY_CURRENT_USER\Software\QlikTech\QlikView\Module Checksums Safe

HKEY_CURRENT_USER\Software\QlikTech\QlikView\Module Checksums System

Assuming you're locked out of your doc you would need to remove the appropriate entry under either Checksums Safe or Checksums System. Just remove both the keys and you should be fine and get prompted again the next time you open the document and you can now choose to disable the macros.

Ending Qlikview in a Macro

Fri, 23 Oct 2009 01:49:27 GMT

You can use the /v switch when opening the document.
The /v switch allows you to send in a variable when opening the document.
Then in the macro, test on the presens of the variable and act accordingly...

BR
Hans

Ending Qlikview in a Macro

Fri, 23 Oct 2009 22:59:26 GMT

Thank you!

Ending Qlikview in a Macro

Fri, 30 Oct 2009 22:01:33 GMT

Find Many entires with hex codes; How do I find the correct entry?