Hi Rob, I am not familiar with Macro's writing. But I will give idea how to execute the batch file.
1. Create QVW with Macro to create excel file with multiple qv objects.
2. Setup a Task ok QEMC for reload and call the Macro trigger after post Reload.
3. Create the batch file to format the excel file or email subjects
4. Call the batch file trough external programs on QEMC after successful reload of QV Task.
Unfortunately the client is running QV SBE server with no publisher, Windows scheduled tasks are all I've got to work with.
I found a solution to the problem was to run excel "silently", ie not open the GUI,
Create this directory:
c:\windows\syswow64\config\systemprofile\desktop ( This may not be necessary but it was one of the trhee changes I made)
Then set the windows scheduled task to run with the highest privileges.
For me it basically boiled down to a Windows / Excel problem, QV was behaving as expected. There was a bit more detail in this thread,