How to activate and control modem from VBA Excel

[Leonardo]

Hello ! I am designing an application to access a PBX using serial
connection. I want to access Hyperterminal from VBA, in order to
connect the PBX using a dial up connection. How can I set up, activate,
and send and receive data from modem, using VBA ?

Thanks in advance.

LQ

 

[tony h]

in VBA you need to reference the Microsoft TAPI library. Look for TAP
examples in google. The code is the same as in VB

regard

 

[arthurjr07]

in vb6, we're using MSComm, i think you can also use it in excel.

if you dont have that control, you can download it here.
http://www.yes-tele.com/mscomm.html

and for reference code
http://www.programmers-corner.com/sourcecode/111

HTH

 

[tony h]

go with arthur, the MSComm option is easier