I had the same problem a few weeks ago.
Sadly, there is no way that you can reload such a model through publisher.
I solved my problem (exporting a table from a QlikView Document to Excel and sending it to an User via Email) with a VBScript, so I can execute the script via External Task.
But your problem (distribution it through publisher) doesn't work at this time. Maybe QlikTech will bring up a solution in the near future.
I am currently running this model from my local machine. The reload takes about 35 seconds each time.
I tried copying the model and data to the server and opening the model on my local machine directly from where it's saved on the server. When I did this the reload time went up to about 1min 30 sec.
This way would've been convenient, but this reload time is too long, since the macro reloads twice and the macro is run about 20 times a day.
Any other suggestions anyone?
I was finding a solution for this problem couple of weeks ago.. but I didn't get a solution from the forum..
How I solved that problem is...
I installed Qlikview personal edition in Server and used a batch file to reload that application which is using the macro...
I used personal edition because , it is not fair to use 1 CAL in the server...
Try like that!!