Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ??
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
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