Real Time Collection and Display of Data by Excel
 

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

Real Time Collection and Display of Data by Excel
 

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

Real Time Collection and Display of Data by Excel
 

Thanks Tom,

I had trouble trying that once because it didn't seem like the MSCOMM
control was normally included with the Excel VBA environment. This Excel app
will be sent to customers and I want to avoid doing anything too "custom"
that might give users trouble. I will try however bringing my VB app into
Excel. I do a little VB programming, but never anything in Excel's VBA.

"Tom Ogilvy" wrote:

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