Serial Port Communications within Excel

**ExclDawg** · 03-29-2010, 01:58 PM

Hello. I'm looking for a way to communicate through the serial port while in Excel. I used to use Excel 2003, and had MSComm objects setup to work within my code. With these objects, I was able to trap on incomming comm events and parse any new data that was coming from the serial port.

However, when I moved over to Excl 2007, the MSComm object seems to have gone away, and I can't find any replacement object. Does anybody know how to do this kind of thing?

Thanks in advance.

**fredpox** · 03-29-2010, 03:10 PM

Hi,
you may want to give a look at this:-)

bye
P.

**ExclDawg** · 03-29-2010, 03:30 PM

Originally Posted by fredpox

Hi,
you may want to give a look at this:-)

Thanks for the link, however I'm still getting an error when trying to insert the MSComm object. ("Cannont insert object"). I'm wondering if this is because I'm using Windows 7, and the MSCOMM.OCX file isn't installing correctly as explained in your linked post?

When I run the register32 to install the OCX in Command prompt ... it says it installed successfully. However when I attempt to insert the object into an Excel sheet, I get the cannot insert error.

**fredpox** · 03-29-2010, 04:49 PM

Hi,
I don't know if this makes any sense in your case, since you already registered the OCX but I'd try to unregister and register again the .OCX file.

Run cmd and type the following to unregister the OCX
C:\WINDOWS\SYSTEM\REGSVR32.EXE /u C:\WINDOWS\SYSTEM\MSCOMM32.OCX
and then after the message pops up type this to register again the OCX
C:\WINDOWS\SYSTEM\REGSVR32.EXE C:\WINDOWS\SYSTEM\MSCOMM32.OCX

Unluckily I'm by far not an expert on this and I'd wait for other gurus help.

bye
P.

**ExclDawg** · 03-29-2010, 04:57 PM

Still no luck. I'm thinking it might have to do with the registries.

I did what was suggested, and added in this reg entry:
HKEY_CLASSES_ROOT\Licenses\4250E830-6AC2-11cf-8ADB-00AA00C00905

And set the (Default) to: kjljvjjjoquqmjjjvpqqkqmqykypoqjquoun

Is there another registry I need for it to work? Do I also need to have Visual .NET installed on the system for this to work? (I was hoping I could run this outside of a Dev environment as well).

Thanks!

**Burly21** · 09-07-2010, 11:39 AM

Hi ExclDawg.
If your W7 is 64 bit try to paste the MSCOMM32.OCX in the folder "SysWOW64" no in "System32" and register in this folder. Remmember unregister and quit the OCX of System32.

**MikeHaras** · 10-18-2013, 05:15 PM

I know this is an old post but this may be of use to someone, could not get mscomm32 to work and eventually stumbled on to an ocx file called NETComm, this is a free download and must be registered under the system32 directory in win 7 64bit.