I am working on the following test system:
Barcode reader connected to PLC reads label.
The PLC search for this number in Column A of an Excel file (Up to 2000 rows in Excel file)
PLC reads about 10 cells in the row with the matching number to set up system.
Test is performed.
PLC writes number read from label and one measured value to the next row in another Excel file.
I am planning on using either an AB Micrologix 1200 or Siemens S7-226 PLC. How difficult is it to do as mentioned above? Can a Excel VBA macro handle most of it or is extensive PLC logic required?
Thanks,
Adrian
Barcode reader connected to PLC reads label.
The PLC search for this number in Column A of an Excel file (Up to 2000 rows in Excel file)
PLC reads about 10 cells in the row with the matching number to set up system.
Test is performed.
PLC writes number read from label and one measured value to the next row in another Excel file.
I am planning on using either an AB Micrologix 1200 or Siemens S7-226 PLC. How difficult is it to do as mentioned above? Can a Excel VBA macro handle most of it or is extensive PLC logic required?
Thanks,
Adrian