Duane - I'm definitely interested in your sample Excel
with serial VBA. Could you send it to me? I have Ofiice
2000 Professional edition - how do I know I have the
license to use MSComm?

Cheers

Karl

-----Original Message-----
Actually you can do serial I/O is Excel pretty easily
using VBA as
long as you have a license to use the MSComm Control. I
wrote an
application and created an InstallShield Installation to
install the
MSCOmm ActiveX Control. I have an example Excel
spreadsheet with VBA
code for managing serial I/O. Drop me an email if you
are interested
and I'll email it to you.

I've used this technique for a number of project for
serial
communications to PIC and Atmel processor, and
simulations of these
processors on other PC's. I've even used it for multiple
serial ports
(two). Works with USB virtual comm ports are well.

Duane Mattern
Boston, MA USA

- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - -
On Wed, 28 May 2003 21:57:26 GMT, (Thomas
Lutz) wrote:
There is no easy way to do serial I/O directly in Excel
without using
a 3rd party tool.
The easiest tool for doing simple RS232 serial I/O
directly in Excel
would be a product called WinWedge from TAL Technologies.
For more information on WinWedge visit:
http://www.taltech.com

- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - -
On Sun, 25 May 2003 00:23:36 -0700, "Dave Y"

wrote:
Can anyone point me in the direction of some VBA code
that
will allow me to send strings of characters to a Serial
port and read strings (or single bytes) back please? I
have done a lot of searching adn other than commercial
packages, have found little of use.
Thanks
Dave Y
Brisbane
downunder

.