View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ftca Ftca is offline
external usenet poster
 
Posts: 10
Default need help re send/recieve com port data from excel and auto CR/LF

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