Can I use COMM port in Excel VBA?

G

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
 
N

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
 
N

NC

Galin Iliev,

Thanks a lot! I shall try it.

NC

Galin Iliev said:
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
Click to expand...
 
Top