When exporting to Excel Forecast Studio is looking for files with static name. The batch file should have the name "ExcelExport.bat" and must be located in the "%appmaindir%\scripts" folder. The file is called twice, but with different arguments, once before the export and once after.
The following arguments Forecast Studio sends with the call to the "ExcelExport.bat" batch file:
Argument before the export:
“PRE” “excel”
Argument after the export:
“POST” “[TemplateName]”