Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Want to exit from Qlikview when my macro finishes; How is this done?
Try this, bye
ActiveDocument.GetApplication.Quit
Thank you!
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).
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.
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
Thank you!
Find Many entires with hex codes; How do I find the correct entry?