RS-232
 

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

RS-232
 

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.

RS-232
 

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

HTH, Greg

"clockman" wrote in message
...
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 ?

thx

RS-232
 

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.

"clockman" wrote in message
...
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 ?

thx

RS-232
 

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



On Thu, 29 Apr 2004 04:26:03 -0700, "clockman"
wrote:

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 ?

thx

RS-232
 

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 ;)