serial port mscomm32.ocx in excel
 

It is possible to use mscomm32.ocx in excel vba. If you already have
vb on your computer than it works in vba but if you don't, you must do
the following.

Get mscomm32.ocx and place it in your windows\system directory.
Get vbctrls.reg off a vb installation cd or internet and save it where
you can install it into the registry.

Now, go to start--run and type the word command
A dos window will appear.
Type C:\WINDOWS\SYSTEM\REGSVR32.EXE C:\WINDOWS\SYSTEM\MSCOMM32.OCX
this registers the control

*************
(should you wish to unregister it for some reason do this below)

C:\WINDOWS\SYSTEM\REGSVR32.EXE /u C:\WINDOWS\SYSTEM\MSCOMM32.OCX
**************

Now type regedit in the dos window to start the registry editor.

Import vbctrls.reg

You may have to restart the computer now.