Excel File to App Server using OLE

I have a program in which I am creating Excel output via OLE. It works great! But my users need to run the program in the background. When running in the background, I cannot output to a local file. Is there a way to output my Excel sheet to the App Server using OLE?

I have seen posts where I can use the 'Transfer' command to put it on the app server like I would for any other file, but in doing this my formatting is not passed.

Is there anything I can do?

Thanks,

Mary