Industrial Automation
Industrial Automation | Europe

myKnowledge

Main > Product Type > Software > Visualisation
Minimize Text   Default    Enlarge Text
 

Print
E-mail

Shop Floor Data Collection With CX-Server Lite and Excel/VBA


Introduction
Requirements:

MS Excel97 and CX-Server Lite need to be installed on the computer.

The communication for the connected PLC must be configured or a CDM project has been created. Patterns BDE.cdm see below. This must be used depending on the PLC and the network used settings.

A directory C: \ Data must be created. Then the file Dummy.xls (see below) is copied / detached.

(Added: H.B:
If FINSGateway is no longer installed on the computer, the corresponding references can be voted out. (VBA / Tools / References))

How to use the programs:

BDE_Tabelle:
Reads data from a PLC into a table with a fixed format and stores them in specified time intervals (here: 1 minute) in a new worksheet in the folder C: \ Data from.

BDE_Liste:
Reads data at fixed time interval from a PLC and writes it with a timestamp (here: every 5 seconds) with each other in a table, ie each group of values in a new line (data recorder). In fixed time intervals (here: 1 minute), the data in a new worksheet in the folder C: \ Data saved.


Dummy.xls The file contains a blank worksheet, in which the collected data will be copied. Then it will be saved under a new name. This file is required for both examples.



Attachments

BDE.cdm - Size: 30720
CX_BDE_Liste.xls - Size: 75776
CX_BDE_Tabelle.xls - Size: 48640
Dummy.xls - Size: 13824


Comments (View All Comments / Add Comment)

Related Articles
No related articles found.
Created 2009-06-15
Modified 2009-06-15
Views 4105

 

You are not logged in.