Real Time Collection and Display of Data by Excel

[Steve Landry]

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

 

[Tom Ogilvy]

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.

 

[Steve Landry]

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.