on error lnerr=.t. oExcel=GETOBJECT(,"Excel.Application") on error if type("oExcel")="O" with oExcel ....>There is an application that interfaces to a Gas chromatograph that analyzes a gas sample and stores readings to a log file or stores the readings into an open Excel workbook. I can get the data from the log file once it is written but the problem is that the program only writes the log file when you stop the process and manually save the log file then restart the process. It can be programmed to writes the data to an open excel workbook, but the problem with this is that it writes to the the same cells every time it writes (every 4 minutes). When this is a batch process that is attended it is easy to stop the process and save the log file and put this intop a table for calculations. I now have the need to run this as a continuous process for a period of several weeks and automatically capture the data when it is written to the excel workbook and save it to another table since it is continuously overwritten in the workbook.