Excel Serial port connections

[derf]

I would like to capture data form a serial port to an excel spreadsheet.&nbsp;&nbsp;I am sure that there is an easy way to do this but for the life of me I can not capture the data.&nbsp;&nbsp;Any suggestions would be appreciated.<br><br>Thanks!!!

 

[ThePhan]

derf,
I am looking to do the same thing and not able to find the way to do it yet. Have you get any answer for this yet? And if you did do you mind to share it?
Thanks
ThePhan

 

[John Lewis]

Well . . . Have never done it, no desire to try, but I would start with the mscomm control.

Open a VBA window, insert a user form, open the toolbox bar (if it's not already open), right click and select 'additional controls'. Scoll down to 'Microsoft Communications Control', mark the box and hit ok. Drag the telephone icon to your new form.

Click on the control to highlight it and hit F1. On your own from there, use it in VB all the time, but haven't tried in VBA.