plcforum.uz.ua

International PLC Forum
It is currently Wed May 23, 2018 2:35 am

All times are UTC + 3 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
PostPosted: Sat Jun 06, 2015 10:00 am 

Joined: Sun Dec 30, 2007 11:03 am
Posts: 92
Location: Mexico
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. :mrgreen:


Top
 Profile  
 
PostPosted: Sat Jun 06, 2015 9:14 pm 

Joined: Fri Oct 03, 2008 5:17 am
Posts: 15
Location: America
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!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 3 hours


Who is online

Users browsing this forum: Google [Bot] and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by International PLCforum® Forum Software © PLCforum
Mobile version