You are limited in what you can do during the reload script with regards to firing a macro to write to Excel. Firing a macro like the one above will be fine on post reload - but I'm not sure it will fire correctly if refreshed from QlikView Server.
The simplest way to export data for use in Excel during reload is to do it as a CSV file, a simple store statement can be used to do this:
STORE TableName INTO .\DataFile.csv (txt);
If you want formatted Excel output then you need to look at a product such as NPrinting, which allows you to write to a pre-defined template, with headers, different fonts and multiple tabs.
Please get in touch if you would like more information about NPrinting.