I've renamed the settingsfile and ran the script again. I got a message about the language settings and changed it to English and after that I got a message about allowing Macro's which I agreed and an other warning about giving access which I also excepted. Then the reload started but no Excel file.
When I run the macro manually, I get the message box and after that I get a window for running the macro. I changed the settings for only running in safe mode and then the Excel file was created.
Just try it again but not with the export else with the msgbox and then selection-statement. Also another check that really the right macro-routine is called from the OnPostReload trigger. Further if there other actions which are also called by opening/reloading the application remove them.
Another check is - what happens if you don't execute the batch and don't starts the macro manually in the application else just reload the app - the macro fires or not?
There might be various reasons. At first would be a check if any new Excel instance will be started - you could see it within the taskmanager. If not your create-statement might be jammed through any security settings (it's an ActiveX feature and needs to be enabled - and there might be differences if a call comes from the UI or from a batch and further important is of course the USER which called the batch) and/or there might be any popup's which you didn't see if you set the visibility and the messages to FALSE.
Another point is your code itself - there are at least some references which look unusual for me. Means for example the paste-statement which hasn't a reference to a sheet:
else only to the application. If you say but it worked manually I would repeat the above mentioned that there might be differences between an UI call and a batch call (for example in regard in early/late binding of features). I'm not an expert here but I struggled already in this regard ...
But is there something within the code Excel should show it to you (after enabling the visibility and the messages) and also an On Error Resume Next and then msgbox err.number & " - " & err.description should give some valuable hints.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.