Great demo. Thank you, Peter. I don’t think many professionals in our industry realize this is possible. I’ve gotten some blank stares.
@iantogriffin9928
Жыл бұрын
Excellent demo. thanks for posting.
@tomtom3906
4 жыл бұрын
Thanks Peter good demo!
@mesclau
4 жыл бұрын
Great!!!!
@sergiofranciscomayoralcruz8037
Жыл бұрын
Can i use this funcion if i have a Micro820 and a ML1200?
@LearnSomethingHelpful
3 жыл бұрын
Thanks for the video, I do have a suggestion from our findings in the past few months & speaking with Rockwell. If you try this on Windows 10 & any version of Microsoft Office above 2016 & it no longer works...DDE is what is used & it is now disabled so moving forward any command codes should be used in a real OPC not DDE like the copy-paste method. There are a lot of other tools to use & Rockwell Automation themselves has demo excel files to read & write data. DDE is broken after Excel 2013. You can try to enable it but depending on what version of RSlinx you are using, it will break. Standard in the field as of 2021 is Windows 10 MS Office 2016 or even MS office 365
@superezbz
3 жыл бұрын
I haven't tried it yet, but: docs.microsoft.com/en-us/office/troubleshoot/excel/security-settings
@LearnSomethingHelpful
3 жыл бұрын
@@superezbz I have worked closely with RA & there is no fix besides transitioning directly to OPC or making your own data move in Python. OPC is easier. DDE is gone for new Windows & Office
@superezbz
3 жыл бұрын
@@LearnSomethingHelpful I figured out how to do it on an offline program. First, you export a rung that is referencing the array. Then, you open the L5X file in a text editor. You will see that tag data values are in the L5X text. Copy and paste into excel. Edit the values. Copy the excel code back into the text editor in the appropriate place. Then, this is very important, delete the rung AND the array from the controller. Then import the L5X back in. You will now have your rung back with a fully populated array.
@LearnSomethingHelpful
3 жыл бұрын
@@superezbz We are talking about reading tag values not rungs
@superezbz
3 жыл бұрын
@@LearnSomethingHelpful I know. I'm talking about writing tag values en masse. It works. It is the only way I have found that is capable of doing it offline or online, without extra licensing or running a Windows 7 VM or machine. When you export the rung or routine, the tag values are written into the XML file. Those can then be manipulated and re entered into the program. That's it. If you are really good, you could write code in XML if you wanted to, including populating arrays. However, I find that writing repetitive code is best accomplished in Excel. Excel is far superior in data manipulation than Studio 5k.
@DuneKraftwerk
Жыл бұрын
Wow DDE... remind me 1987..
@AfroMan187
15 күн бұрын
Any way to export a data file to a PC that doesn't have RS Linx?
@PSDettmerMATC
13 күн бұрын
There are other "data servers" available. Some offer a free 30-day trial and/or 2hr runtime. Look at Kepware. Depending on your FW version and controller, you could also look at OPC UA....
@caseymarionneaux2507
2 жыл бұрын
Would this be possible from a web page that is ran from a local server using HTML, PHP, Javascript or some other language?
@PSDettmerMATC
2 жыл бұрын
Very likely that this could be done via Modbus protocol to exchange data via any of the languages you mentioned.
@ansonkiek6471
2 жыл бұрын
rslink classis lite can?I don’t see the copy option this my classic lite please advise. I am using studio 5000
@PSDettmerMATC
2 жыл бұрын
I don't think so. You need a version that can act as a server to exchange data. Most likely Gateway.
@ansonkiek6471
2 жыл бұрын
@@PSDettmerMATC is this only available on rs link professional?
@PSDettmerMATC
2 жыл бұрын
@@ansonkiek6471 There are 5 versions of RS Linx Classic. It depends on what OPC service you need. Single Node provides some OPC/DDE service. Best to talk to your distributor to see what you need. We use RS Linx Classic Gateway. It has all the functionality. compatibility.rockwellautomation.com/Pages/ProductReplacement.aspx?crumb=101&restore=1&vid=50022
@jorgelopez-dd3gb
Жыл бұрын
It's possible do the same with Micrologix PLC??
@PSDettmerMATC
Жыл бұрын
Yes, there is sample code available for RSLogix 500 based controllers. Communication settings depend on your protocol (Ethernet IP/ Serial, etc....). You need RSLinx with the DDE/OPC capability. Good luck!
@flavioscarazzato6088
3 жыл бұрын
Can you share the excel file used in this video?
@PSDettmerMATC
3 жыл бұрын
Sure, please go to the About section on our channel and select the "Send Email/Message" option. I'll reply with a copy of the .XLS file.
@mattemburgh7188
4 жыл бұрын
Hello! How can I set this up so it logs the data every 24 hours automatically, without using a push button?
@PSDettmerMATC
4 жыл бұрын
The button just triggers the Macro. You can write a separate Macro to trigger the "Data Collect" Macro at specific time intervals. Search for this on KZitem: Automatically Run a Macro Every X Minutes or Hours - Good luck!
@4ngel012
2 жыл бұрын
great video. Where can I learn about more rslogix functions to use in VBA?
@PSDettmerMATC
2 жыл бұрын
You can look up information in Rockwell Automation's Knowledge Base. Search for topics on DDE/OPC/VBA they have some good sample code and files.
@4ngel012
2 жыл бұрын
@@PSDettmerMATC ok, muchas gracias
@pjeremy1449
Жыл бұрын
How does this work with strings?
@PSDettmerMATC
Жыл бұрын
Not sure. Haven't tried that yet. I'd expect very similar, just a matter of changing the data types?
@LeoGarCru
3 жыл бұрын
Where to learn VBA to do things like this ?
@PSDettmerMATC
3 жыл бұрын
Look at your local College for MS Excel & Visual Basic for Applications courses. Otherwise, LinkedIn Learning and other online training.
@DuneKraftwerk
Жыл бұрын
Excel online...oops.. code scripts and socket io can make it works not DDE
@jackdtdt4121
3 жыл бұрын
Hi ! Peter ! Great Demo! Can you share me the Excel File in the Video?
@PSDettmerMATC
3 жыл бұрын
Please send me an email. My email is in the video. Thanks, Peter
@pk_hemmane
4 жыл бұрын
pls share the excel link
@PSDettmerMATC
4 жыл бұрын
Not sure which Excel link you are referring to?
@JamesRobinson-hq4lt
Жыл бұрын
@@PSDettmerMATC I believe he is referring to segment at 3:42 where you are pasting the link but the video is blurry and we can't really make out what type of brackets or parenthesses are being used.....
@PSDettmerMATC
Жыл бұрын
@@JamesRobinson-hq4lt send me an email and I'd be happy to share the code and Excel file with you.
Пікірлер: 43