05-06-2010 01:11 PM
05-06-2010 01:56 PM
I don't see where you enabled any indexing, but I do see you added a shift register and you concatenate the data together. Now your file writes only one time, and all data should be there. One more suggestion, clean up your wiring. Its hard to follow when you have hidden wires and when the wires don't meet up with the terminals on the loop borders and case borders.
05-06-2010 02:02 PM
Hi tbob,
Thanks so much, I guess I solved the problem based on your first idea... The program generates the file name from 0-9 when I run it. please see the attachment.
Lei
05-06-2010 02:03 PM
05-06-2010 03:06 PM
Either you attached the wrong file or I'm going crazy. I don't see where the filename is being changed. The Write To Spreadsheet function is called only one time, after the loops have all finished. It produces one file only.
You still have not cleaned up any wiring.
05-07-2010 09:27 AM
Hi Tbob,
Sorry I didn't change the file name, but the problem is solved. Thanks so much,
Regards,
Lei