Data Collection with Citect & Excel

mjm

Member
Join Date
Aug 2005
Location
Albuquerque, NM
Posts
12
I need to collect data from all the variables in my citect program. How do I set up an open button that when clicked will open an excel file and write the variable data and then close when I click a close button???

Thanks,

mjm
 
You'll need to write something in Cicode for this.

I've recently done a project writing variables to an .mdb database.

I did all the database comms using SQL in Cicode.

I'm afraid there's no quick and easy way.

JT :)
 
mjm said:
I need to collect data from all the variables in my citect program. How do I set up an open button that when clicked will open an excel file and write the variable data and then close when I click a close button???

Thanks,

mjm
You can get Citect to open just about any file. Flick through the example project to find a button that does it and dive in there to work out how.

If you are opening an Excel file and the data is stored in the PLC then you may be able to use DDE to retrieve the data from the PLC. You may need to spend money on a version of RSLinx that supports DDE.

Just food for thought, the Access Database option may still be best for you.
 

Similar Topics

Hello, I am new to the forum, so I am hoping that someone will be able to help me. I am designing a GUI in Citect that will be used with...
Replies
2
Views
3,608
Hi everyone, got a Siemens S7-1200 collecting data off one our furnace lines. I'm getting some interesting activity I'm working on cleaning up in...
Replies
6
Views
684
Never done this before We have a customer that would like to collect data, dwords, from 4 devices and read to an HMI. Then send that data to a PLC...
Replies
10
Views
2,054
I wanted to get some opinions and maybe a point in the right direction for products on networking machines for data collection. Im not all that...
Replies
15
Views
4,794
Hello All, I am looking for a way to get the data/information from METASYS BAS of Johnson Controls. I would like to get this data into Inductive...
Replies
4
Views
2,342
Back
Top Bottom