The requirement is for Excel to collect data from a serial comm port and add
it to a worksheet one line at a time. The data stream is a comma delimited
ASCII text string terminated with a carriage return. The data is from a
laboratory instrument that transmits the results of each test. Can Excel be
used receive data directly from a comm. Port? I currently have a VB app that
collects the data and puts it into a CSV file. Would having Excel
periodically read the CSV file be a better approach?
Best Regards, Steve