Sharing One Scale with Two PC

L

Thread Starter

Liya

Hi,

Is there a possibility to share one electronic weighing scale machine using RS232with two PCs and automatically key in the data through excel?
 
J

Jeremy Pollard

Sure... use the receive line to both serial ports.. or get a sniffer cable which has 3 ports... one to the scale, and the other 2 to the PC... can also use a serial splitter cable. Available anywhere ...

Cheers from: Jeremy Pollard, CET The Caring Canuckian!
Crisis, necessity, change

Integrator, Educator, Consulting, Columnist - Control Design
 
It is very easy to do. Just split the TX cable and GND cable.<pre>
SCALE TX ---------- PC1 RX
|--------- PC2 RX


SCALE GND ---------- PC1 GND
|--------- PC2 GND</pre>
For the automatic key-in data into excel: you can develop a program that runs in the background. This program will receive the RS232 data and paste it into excel sheet.

Or develop a program and store the data in database, then export the database to excel.

Bronson Alex
http://www.pt-altraman.com
 
Top