![siemens step 7 excel sheet read online tags siemens step 7 excel sheet read online tags](http://www.plctalk.net/qanda/uploads/S7_Counters.jpg)
- #SIEMENS STEP 7 EXCEL SHEET READ ONLINE TAGS HOW TO#
- #SIEMENS STEP 7 EXCEL SHEET READ ONLINE TAGS CODE#
- #SIEMENS STEP 7 EXCEL SHEET READ ONLINE TAGS PASSWORD#
- #SIEMENS STEP 7 EXCEL SHEET READ ONLINE TAGS DOWNLOAD#
![siemens step 7 excel sheet read online tags siemens step 7 excel sheet read online tags](http://www.plcdev.com/files/plcdev/images/S7-View-Online-Icon-no-mouse.gif)
#SIEMENS STEP 7 EXCEL SHEET READ ONLINE TAGS PASSWORD#
Delete the Encrypted Password (Open Locked Microsoft Excel) As you can see, the methods are divided into 2 groups. Hey, before you dive into it further, ask yourself if you know the Excel password. Put it simply, you set a password to encrypt your workbook/spreadsheet, and now what to remove password protection from Excel, do you? OK, here you'll find 7 effective solutions! The only thing you have to do to make this Excel sheet work, is make sure there is an DDE/OPC topic in your RSLinx setup called 'EXCEL_TEST', and the arrays REAL_Array and DINT_Array in your controller (of at least length 10)."How to remove the password from my Excel file and sheet? What is the way of removing the protection?."
#SIEMENS STEP 7 EXCEL SHEET READ ONLINE TAGS CODE#
To make this easier on everybody, I've included the Excel file with the code already in it. The way this is implemented is of course very rudimentary, but once you get the concept, the sky is the limit. I would like to be able to change the values in the cells, and then hit a 'Write Data' button.įirst, make another button on the sheet (mine looks like below now)
#SIEMENS STEP 7 EXCEL SHEET READ ONLINE TAGS HOW TO#
Now we know how to read, it would of course be a lot of fun if we could write values as well. To save you all the steps to program the rest of the code, here is the final code to get the array of REALs out of the controller, and put them in cells D2 – D11, and the array of DINTs in cells E2-E11. The variable 'rslinx' will hold the number of the open channel. All subsequent DDE functions use this number to specify the channel. Now, if I call this function from the CommandButton1_Click event, it will open the link to RSLinx: This will take you to the Visual Basic Editor:įirst, create a function that will open the DDE topic to Excel: When you have the button, right click on it and choose 'View Code'. You can find the Command Button control in the 'Control Toolbox' toolbar in Excel. On this workbook, place a new command button. Let's start up good old Excel, and create a new workbook. I'm not going into detail about that, but I did make sure this worked before continuing with the next step, creating the Excel sheet. To test if your setup is working, at this point you can use the OPC test client provided with RSLinx. In order to do this, you have to click the 'New' button, give the topic the desired name, and make sure the processor in slot 2 is selected as the source before you click 'Done' I'm going to create a new DDE/OPC topic called 'EXCEL_TEST', and use the Logix5550 processor in slot 2 as the data source. Now, open up the DDE/OPC topic configuration by clicking 'DDE/OPC' and then 'Topic Configuration' in the top menu of RSLinx. The one in slot 2 is the processor we are going to use for this exercise. The setup I use looks like this in RSLinx:Īs you can see, I have a 10 slot CLX rack, with a 1756-ENBT card in slot 1 (address 134.200.211.16), and two processors, one in slot 0, and one in slot 2. Depending on the version of RSLinx you use, it might look slightly different, but you should be able to follw this with the screenshots.Īssuming that you know how to setup RSLinx initally to get online with your controller, I've skipped some steps. Next, we're going to set up a DDE/OPC Topic in RSLinx. I'm not going to do anything with the PLC program, I just need some data in a number of tags. In this example, I created 2 arrays, of the types DINT and REAL, each with a length of tags. Let's fire up RSLogix first, and create a bunch of tags with values.
![siemens step 7 excel sheet read online tags siemens step 7 excel sheet read online tags](http://www.plcdev.com/files/plcdev/images/S7-Do-you-want-to-delete-the-system-data.gif)
#SIEMENS STEP 7 EXCEL SHEET READ ONLINE TAGS DOWNLOAD#
Have you ever lost data in a CLX processor, because you downloaded new code? Unfortunately, when you donwload a program to a ControlLogix processor, you also download the values of the tags (variables).Ī solution to this problem that could be useful, is an Excel sheet that reads and writes values to the ControlLogix processor using the DDE/ OPC capabilities of RSLinx.