Mar 13th, 2013, 06:42 PM
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?
Mar 14th, 2013, 12:45 PM
Re: Complete noob
A "COM port" has nothing to do with COM and ActiveX.
Excel topics really belong in the Office Development forum and not the programming forums here. Office VBA macro scripting is included there as a courtesy though it doesn't really belong here at all.
Consumer SKUs of Office (and Excel) do not incude any serial port controls or any license allowing you to "borrow" controls such as those shipped as part of VB6. For this you'd need Office Developer Edition (or the equivalent for versions of Office after XP/2002).
You might also look for some 3rd party library intended for this purpose.
Click Here to Expand Forum to Full Width
Survey posted by VBForums.