I have an outside program that feeds measurement results into Excel. The programming of this outside software only allows the insertion of data into one column of a worksheet, Column C. Currently, we need to manually open the excel sheet, insert a new column, and close the worksheet between measurment runs. My question is whether there is a way to program excel to automatically insert a column when this outside program opens or closes the worksheet? Any insight on this subject would be very much appreciated.

Mike