Read data from MSCOMM using Excel 2010 and VBA

Question

0.00/5 (No votes)

See more:

In previous version of Excel I been able to read data from the comport using Excel and VBA.
When doing that I added an comport in an userform and wrote code inside the userform which read the data form comport.
My problem is that I can’t find out how to add the comport to the userform.
Do anybody know how?
I registered the MSCOMM32.ocx running this bat file:

regsvr32 %windir%\syswow64/MSCOMM32.ocx

Posted 8-Jan-16 0:49am

Koppelgaard

Updated 8-Jan-16 1:27am

Richard MacCutchan

v2

Add a Solution

Comments

Maciej Los 8-Jan-16 10:46am

How To Use MSCOMM32.OCX to Transfer Data on DBCS Windows[^]

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2016-01-08T04:49:00

Solution 1

Take a look here: How To Use MSCOMM32.OCX to Transfer Data on DBCS Windows[^]

Posted 8-Jan-16 4:49am

Maciej Los

Comments

Koppelgaard 8-Jan-16 13:47pm

As far as I can see the example involves Visual Basic.
I only got Excel and VBA and need – I think – to place an comport ICON in a USERFORM in order to get data from the comport.
Correct me if I’m wrong.

Maciej Los 8-Jan-16 14:01pm

Yes, that has been written in 2. point
"Place Microsoft Comm Control on Form1. If Microsoft Comm Control cannot be found in the control bar, go to Tools menu, choose Custom Controls, and then check the Microsoft Comm Control on the List Box."

Koppelgaard 8-Jan-16 14:17pm

But they are talking about VISUAL BASIC and I only got VBA and under VBA’s tool menu I can’t find any Custom Controls

Maciej Los 8-Jan-16 14:27pm

Open VBA code editor window. Add new UserForm. Go to Toolbox and right-click on it. Choose "Additional controls". Find and select MSCOMM32.ocx. Now, you're able to place this control on the form.
Cheers,
Maciej

Koppelgaard 8-Jan-16 16:55pm

Now I managed to find the control. I selected ‘Microsoft communication control’ and then the control was visible. BUT when I try to drag it into the Userform I get following message:
‘The control could not be created because it is not properly licensed’

Maciej Los 8-Jan-16 17:07pm

Follow this steps: You receive an error message "You do not have a license to use this control" [^] - method 1
Visit this site too: Visual Basic 6.0 Downloads[^]
And finally this: Description of the cumulative update rollup for the Visual Basic 6.0 Service Pack 6 Runtime Extended Files[^]

Koppelgaard 8-Jan-16 17:30pm

try it tonmorrow :)

Koppelgaard 10-Jan-16 5:32am

You want me to install Visual Basic 6.0 - correct?
I visited: Visual Basic 6.0 downloads
Which of the 4 links am I going to use?

Maciej Los 10-Jan-16 5:50am

Yes! You have to install VB 6.0 Service Pack Runtime Extended Files, which contains MSCOMM.ocx. Then you'll be able to use it.

Koppelgaard 10-Jan-16 6:02am

sorry to be bothering you, again, but there a so many possibilities.. Which link exactly?

Maciej Los 10-Jan-16 10:52am

The last one.