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

[dhasharadh]

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

[marcus_sommer · Accepted solution]

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