Can I use COMM port in Excel VBA?

[NC]

Can I use COMM port in Excel VBA???
If can, how can I use? Thx!

 

[Galin Iliev]

why not.
add refference to mscomm32.ocx and add instance to any of your VBA forms.
and you can use it.
Have a nice coding )

Galin Iliev
MCSD

 

[NC]

Galin Iliev,

Thx, but how can I add reference to MSCOMM32.OCX and add instance.
Could you give me a very simple exsample. Thanks a lot!

NC

 

[NC]

Galin Iliev,

Thanks a lot! I shall try it.

NC

NC,
these are the neccesary steps for using MSCOMM32.OCX
1. Open Excel
2. Open Visual Basic Editor
3. RightClick somewhere on Project tree (usually on the left) -> Insert ->
UserForm
4. From the menu - Tools -> References -> Microsoft Com Control 6.0
(MSCOMM32.OCX) - or click browse and point the file
5. RightClick somewhere on Project tree (usually on the left) -> Insert ->
Module
6. write sub or func that declare variable from type MSCommLib.MSComm
this is it
I attach one xls.file that has all these things )))

Good Luck
If you have any questions do not hesitate to ask me.

Galin Iliev
MCSD