I've got a question here that may sound crazy but here goes.....

This is what I'd like to be able to do:

I have a CNC milling machine hooked up to my PC. I have the CNC program sending out info to the PC at the end of every part cycle. I use the machine's internal part counter and timer and it outputs the cycle time of each part.

"PART 20 of 5000 CYCLE TIME- 430 SEC."

At the end of every cycle the software on the PC receives this info and creates a new txt file, naming it NEW1, NEW2,......

NEW "PART 20 of 5000 CYCLE TIME- 430 SEC."
NEW1 "PART 21 of 5000 CYCLE TIME- 435 SEC."
NEW2 "PART 22 of 5000 CYCLE TIME- 440 SEC."
NEW3 "PART 23 of 5000 CYCLE TIME- 428 SEC."
ETC.


What I'm looking to do is have the most recent part number/cycle time
be dropped into a specified cell in excel and overwrite the previous info.
I only want excel to deal with one cell and the most recent info.

The 2 things I don't know how to do are:

1.set-up the cell to only "hold" the most recent input,and overwrite the last.

2.set-up the cell to either "look" to the next text file during refresh(NEW1, NEW2,ETC.)
or delete the file it just imported info from so that the next file created by the CNC will be the same
name as the previous.

If I can somehow get this to work I can send production info to our electronic bulletin board.


ANY help you could give me would be greatly appreciated


Thanks,

Scott