Comm32 Logo
Home Button   

Topic:   Use with VBA in Excel 2013

By: ToddPosted on: Nov 26 2015 at 03:12:15 PM
I'm have trouble using this in Excel 2013 and Windows 7. I need to code some serial communications in VBA (using Excel) and the Comm32 is not showing up in the ActiveX controls list. How do I register this component in order to have in show in the list?

By: GuestPosted on: Nov 29 2015 at 12:48:32 PM
Shouldn't need any additional regisitration if you installed it using the installer from the comm32.com website.

When you go to select the ocx if it doesn't appear in the list, is there also a browse button or register custom option allowing you to navigate to the ocx file and select it?

By: GuestPosted on: Nov 29 2015 at 12:49:49 PM
You can't just copy the ocx to a computer and use it in a project. You need to run the installer that you download from the website.

By: ToddPosted on: Nov 30 2015 at 03:17:34 PM
I have used the installer to install the software. I have also tried the "Register Custom..." button on the "More Controls" dialog box in Excel. However, when I browse and select the Scomm32.ocx file in the WindowsSysWOW64 directory, it returns an error message of "The selected file does not contain any self-registering ActiveX controls."

Is this related to using this control within a 64 bit environment (Windows and Office)?

By: GuestPosted on: Nov 30 2015 at 09:48:40 PM
It's a 32 bit OCX.

If you are using true 64 bit Office then i'm afraid you're stuck. Even many of microsoft's own controls won't work.

If you want to use MS Office to make programs that use any OCX controls then you need to use the 32bit version of Office.