Macro (triggering a button) is not working in QMC ??

dhasharadh — Sat, 16 Nov 2024 00:08:04 GMT

i wrote the below macro for to trigger a button, its not working when i reload it from QMC, where as when i reload manually in the server its working fine.

Sub Export

ActiveDocument.GetSheetObject("BU01").Press

End Sub

Please can any one suggest the possible reasons for this ??

Re: Macro (triggering a button) is not working in QMC ??

marcus_sommer — Mon, 17 Aug 2020 13:30:11 GMT

Within the qmc-reload doesn't exists an ActiveDocument because no datamodel is loaded or created after the reload - just the tables/data will be refreshed and saved. You need to use external batches - which could be triggered in the qmc per EXECUTE. If you searched for it in the community you will find various postings about the topic like:

onPostReload-Trigger-The-Macro-does-Not-Excecute-at-the-time-of
Run-Excel-macro-via-QMC

- Marcus

topic Re: Macro (triggering a button) is not working in QMC ?? in QlikView

Macro (triggering a button) is not working in QMC ??

Re: Macro (triggering a button) is not working in QMC ??