RS-232

[Guest]

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

 

[Guest]

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.

 

[Greg Koppel]

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

HTH, Greg

 

[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.

 

[Thomas Lutz]

The easiest way to do serial communications directly in Excel would be
to use a product called WinWedge from TAL Technologies.
You can learn more about it at:
http://www.taltech.com/products/winwedge.html

 

[Guest]

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

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

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