Marcos cannot be ran by publisher. QVS 9 reference manual page 224. "
QlikView Distribution Service does not execute any macros that may exist in
the Source Document."
You could do an "on open" marco that when the document is open it would do these. Then the server went it open the document would run the macro.
I have another problem.
At present, i'm using QT for polling data from a number of xls file and have a marco that inserts this data into our forecast system. The issue is my reload runs via the server but someone has to open the qvw to push the button to insert the data into the database.
Can this all run via the server?