Printable View
Hi there first of all, i am completly new into VB, i want to learn some because of a project i am intended to do.
I need to be able to read information from a COM port and insert it into excel, i have seen lts of things in the web but haven't been able to do this in excel, i added the mscomm into the regisrty, tried inserting the activex control, but it wont work, it can't be inserted, idk why.
Is this what i should be doing? or is something else needed?
Thanks!
sounds right to meQuote:
Is this what i should be doing? or is something else needed?
add a userform
menu > tools > additional controls
microsoft communication control (mscomm32.ocx)
add telephone control to userform, this may give error and the step above may need to be repeated
i do not know if the mscomm control can be added to a sheet, but as the userform can remain hidden (or not) it does not matter
but how do i read information from the comm port?
use the oncomm event of the comm control
there are many examples in the vb6 forum, or google
i know, i've seen them all, i just can't make them work on excel
Can someone point me out?