can excel use automatic carraige returns? and send/recieve data via com port?

Giganews Newsgroups
Subject: can excel use automatic carraige returns? and send/recieve data via com port?
Posted by:  Ftca (ftca…@hotmail.com)
Date: Sat, 11 Oct 2003

Hi
I need to design a sheet that is of a set size
i.e 20 rows by 20 columns
I'm inputting the data with a barcode scanner (via serial port)
I need the cursor to automatically go to a new line and start of line
once the top line is full of data.
I have spent hours reading help and searching the net but to no success
can someone please help me here?

I also have an even harder problem
and that is -
can excel send a "?" chr via a com port and
then input the response ( a weight in KG) back into a cell?
its a set of scales for animals

Thanks in advance

Replies