I have an Automation script that is published on TIC. It basically uses an "Export activity" to get the export from a SQL query and then run the macro. If I run this autoamtion script from TDP it fires the macro, however if I publish this to TIC it does not fire the macro and just the import can be achieved, I have already "Enabled all Macros" ?
I had this error and reported it here. There is a 4.2 beta that fixes this. I believe the will be a new official version out very soon, so may be best to wait on that.
We released on May 4 (yesterday). Once release support goes through and notifies user of fixes. This done on an individual support case bases and not bulk email. So it takes some time.