Hi There,
I have a QlikView file that runs macros using OnOpen Triggers.
The macros are always triggered, but sometimes they fail without showing an error. Instead of executing, the edit module opens up. No error is shown anywhere. It just stays there until I manually click OK, at which point the other macros (which saves the file and exists) runs. I then have to re-open the QV file, and manually run the macro from a button. This works 90% of the time, but sometimes also just opens the Edit Module screen. I then press the button again and it works.
This is driving me crazy. This macro creates an excel report, and the rest of my daily scripts are all dependent on this report to finish.
It runs perfectly most of the time, and then sometimes fails. It seems to happen more often when the whole script executes later during the day (usually it executes early morning, but sometimes only in the afternoon) - but it's not like the PC is busier then than it is in the morning, so no idea what this could have to do with it.
Please send me any ideas or questions you may have. I have tried sleeping and WaitForIdle within the macro to ensure I am not overworking it - no luck.
Gerhard
