I'm an iSeries developer and know just enough Excel to get into trouble. I have an iSeries application which generates a CSV file of data. This data is generated via a batch process on the iSeries, and we have a mechanism to start excel on a PC type of machine using an XML interface file and a vbScript program which can start Excel with the appropriate template. We want to generate an XLS file from the merging of the CSV file and the associated Excel template. The XLS file will then be e-mailed to the recipient as an attachment so the recipient.

The batch process on the iSeries will run through a scheduler at some time in the early hours of the morning.

The interesting thing is that there is no need for a human, which means there is no need for any on-line interaction.

So the question is, how do we open a template with an associated CSV data file and create the XLS without the work-sheet displaying?

A batch process on an iSeries machine is simply one which does not require any user interaction.

Excel always seems to open in interactive mode.

I've seen a switch which allows a particular template to be used, and another which suppresses the Excel notification window, and I think the answer may be in VBA in the Open event.

I hope I've made sense.

Thanks In Advance.