I have an Avery Weigh-Tronix 127 scale connected to computer with serial cable. Scale is attached to COM port 1. Pressing "Print" on the scale head sends weight recording from scale head to COM. I would like to capture this data arriving at COM1 into an Excel spreadsheet.
Can someone assist with VB script or macro to allow capture of COM 1 data to Excel cell? Possibly also check to see if data is already present in cell and move to next row, same column if so?