Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations JAE on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I get SLC500 information into an excel sheet? 1
- Thread starter maxipaz
- Start date
-
1
- #2
With a DDE driver formula in a cell you do not need to reschedule the reading from PLC since it is performed permanently.
For writing to PLC, which is performed by a macro subroutine execution, you can use vba "OnTime" method to schedule the next execution of the macro.
See also thread791-58495
For writing to PLC, which is performed by a macro subroutine execution, you can use vba "OnTime" method to schedule the next execution of the macro.
See also thread791-58495
- Thread starter
- #3
What exactly do you call a historical report?
Looks like your macro (working every 60 sec) will have nothing with reading from the PLC, but be a kind of data transfer to report area.
And the reading from PLC will still be performed by cells formulas permanently.
Looks like your macro (working every 60 sec) will have nothing with reading from the PLC, but be a kind of data transfer to report area.
And the reading from PLC will still be performed by cells formulas permanently.
- Thread starter
- #5
What I trying to mean by historical report is to bring data from the PLC (integers, floating, bits) via DDE into excel datasheet every 60 secs.
Every reading (performed every 60 secs) should be paste in the next row found empty by the macro in the excel datasheet.
I hope, I made my self clear.
Thank in advance
Every reading (performed every 60 secs) should be paste in the next row found empty by the macro in the excel datasheet.
I hope, I made my self clear.
Thank in advance
maxipaz,
I suggest you the following.
Create a sheet in your Excel workbook named Report or History (or whatever you prefer).
Use row 1 for headers and fill row 2 with any necessary formulas, including DDE links and real time clock/calendar for report records marking.
Determine the last row
for your report sheet, up to maximum 65536.
Create a macro that will:
1. Delete the last row n of the report.
2. Shift down rows 3 to n-1.
3. Copy values from row 2 to row 3.
Execute this macro at any time by any method, OnTime being the most straightforward for scheduling.
As a result, you will have the Report/History of n-2 records in reverse chronological order.
I suggest you the following.
Create a sheet in your Excel workbook named Report or History (or whatever you prefer).
Use row 1 for headers and fill row 2 with any necessary formulas, including DDE links and real time clock/calendar for report records marking.
Determine the last row
for your report sheet, up to maximum 65536.Create a macro that will:
1. Delete the last row n of the report.
2. Shift down rows 3 to n-1.
3. Copy values from row 2 to row 3.
Execute this macro at any time by any method, OnTime being the most straightforward for scheduling.
As a result, you will have the Report/History of n-2 records in reverse chronological order.
chakorules
Electrical
I've done this before. See my download posted here:
Basically I used a worksheet all by itself and used the VBA command "ON CHANGE" to launch the macro. So my PLC wrote data to a sheet all by itself, when the data on the sheet "changed" or "ON CHANGE" event, then I excuted a macro. Check out my download above.
Good Luck
Chris Elston
Automation & Controls Engineer
Download Sample PLC Ladder Logic Code
at MrPLC.com
Basically I used a worksheet all by itself and used the VBA command "ON CHANGE" to launch the macro. So my PLC wrote data to a sheet all by itself, when the data on the sheet "changed" or "ON CHANGE" event, then I excuted a macro. Check out my download above.
Good Luck
Chris Elston
Automation & Controls Engineer
Download Sample PLC Ladder Logic Code
at MrPLC.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
