Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
dhasharadh
Creator III
Creator III

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

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

 

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

 

View solution in original post

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

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

 

View solution in original post