If you have the code for the vbapp, it is highly probably that you can use
that code to create code to read it directly into excel.

--
Regards,
Tom Oiglvy


"Steve Landry" wrote:

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