PLC 5, save data to excel?

[asteroidehk]

Hello friends

I have a PLC5/20, I need to save 2 tags to a excel datasheet.

This tags are: barcode, press force.

I need to save the barcode and press of every part.

how can I do that?

Thanks in advance.

[Guille]

Hi,
you can use an OPC server to comunicate with PLC and use Excel (VBA) to read the tags and store in the excel file or you can store in a database.
There are a lot of info about this. Google (DuckDuckgo is much beter) for OPC client in excel VBA and you can find some code you can use.
Here you can find some code example.

http://www.engineers-excel.com/Apps/OPC/Description.htm


Good luck!