Looking for RS232 API functions for VBA

[tgq]

vba rs232

Hi
VBA doesn't support MSComm activeX
Im looking for a 'ready to use' VBA module for RS232 API functions.
Best should be class module with events on character received on COM port ...

 

[btbass]

rs232 api

Download VB express from Microsoft. It is a free download. It has a commport you can just drop on your form which will expose the comms api.

 

[mmelsadek]

rs232 vba

Hi there

the API functions for serial port are as follow:
1- to Open the Port use:
CreateFile()
2- to Configure the port use:
SetupComm()
SetCommTimeouts()
GetCommState()
SetCommState()
3- to read from the port use:
ReadFile()
4- to write to the port use:
WriteFile()
5- and finally to close the port use:
CloseHandle()

Please refer to you compiler documentation for more information about these function, I use it with the Borland C++Builder and worked well in so many projects

Good Luck

 

[eziggurat]

vba api rs232

Hello,

I am also trying to access the serial port using VBA on Excel.

I have tried using CreateFile(strPort, GENERIC_READ Or _
GENERIC_WRITE, 0, ByVal 0&, OPEN_EXISTING, FILE_ATTRIBUTE_NORMAL, 0) to open the port where strPort is "COM5" (USB serial device) but I always seem to get a -1.

Any help will be great.