RS-232

C

clockman

Hi,
I try to receive data from serial port, but I don't know how can I do it
Is there any communication controller in Excel-VBA

th
 
A

AA2e72E

I've not used this before BUT you can open the serial port for input e.g

open "COM1:" for input as #

Then, #1 is available for Input and Line Input.
 
G

Greg Koppel

You can write a QBasic program to read the data and then use Shell to call
it in VBA.

HTH, Greg
 
H

Hotbird

I have also been frustrated in this endeavour. There is a MSComm1 control
which can be added to a form, and handles serial communication. But I
couldn't make it work. There were registration difficulties.
 
D

DkNukMe

Hello, I had the same problem with MSCOMM registration and I arrive to use it in VBA form. Follows the next tip to register the MSCOMM Control OCX
Copy MSCOMM32.OCX in system 32 director
In Execute Form (Start -> Execute) use the command
Click to expand...
C:\WINDOWS\SYSTEM32\REGSVR32.EXE C:\WINDOWS\SYSTEM32\MSCOMM32.OC
Use REGEDIT command in Execute form to add the following key in the acces HKEY_CLASSES_ROOT -> Licenses
Click to expand...
Key name : 4250E830-6AC2-11cf-8ADB-00AA00C0090
Reg_SEXPAND_SZ value : kjljvjjjoquqmjjjvpqqkqmqykypoqjquou

Now, restart systems and you can use the MSCOMM Control In VBA Application ;)
 
Top