View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hotbird Hotbird is offline
external usenet poster
 
Posts: 18
Default Excel and the Serial Port

I have seen Microsoft Visual Basic applications receive and transmit serial
data through the serial port, managed by the Object/Procedure Private Sub
MSComm1_OnComm(). The serial port parameters are set with the other Form
properties, and my question is: Can something similar be done using Excel?

Initially, I intend to monitor incoming serial data, either in a messagebox,
or a spreadsheet cell, and then develop code to analyse this information in
real time. I have searched the Excel help fles for MSComm1, but have not
found any references to serial communication. Has anyone used the serial
ports with Excel, and if so, could they point me towards relevant background
information, or examples.

In hope..... which has so far not been disappointed......