Communication with Excel & External world via COM port

[Aashu]

Dear Friends,

Most of us have used different softwares, by which any hex/ASCII data can be send to external components such as thermal printers etc. by selecting required baud & other communication parameters. I want to know that is this logic possible by using Excel i.e. if any cell of Excel sheet say "A5" contains a hex data, then how it can be sent to external world from the same worksheet with "19200 baudrate, 1stop bit, none parity" via serial communication port of PC?
Suggest if any reference material or tutorial available for this purpose.

Thanks & Warm Regards,
-----------------------
Aashu

 

[BrianB]

I have been trying, without success so far, to autodial telephone numbers to my modem on COM3. There are methods of doing the job, but they use unwanted userforms.

There are methods using Visual Basic by downloading .OCX comm control(s)and putting into a userform. Or API.

Try a Google search for "visual basic serial com"

I am also experimenting with MSDOS batch files. In particular the MODE command has various forms to direct printer data to a COM port instead of a printer.

 

[Aashu]

Dear Brian,
Thanks for guiding me. Actually I thought that we can do magic in Excel, so serial communication could be simple through excel. I will try for communicating with external world with Excel via COM port & if I got success, I will let other people know. I know how to use VB for communicating with COM port but I tried that whether the same is possible with Excel.


Best Regards,
-----------------
Aashu

 

[BrianB]

What code do you use in VB ?