Dear esteemed members, I am interested in extracting tag values from a PLC to Excel 2021. There are two methods to achieve this: via a DDE link or through VBA code. I am seeking assistance in completing this task using the following steps: 1. Firstly, I would like to create an Excel sheet containing all the tags and utilize a DDE link, with a designated read button. 2. As I am remote from the field, I need to know how to check the sheet in OFFLINE mode. 3. For those familiar with VBA code, which ADD-IN should I incorporate into Excel 2021 to retrieve the data? 4. Does anyone have a reliable VBA code that has been tested specifically for reading data? Please provide me with the necessary guidance to accomplish this task. Thank you for your assistance.
Learn how to establish communication between Excel and RSLinx and send data to a PLC using VBA in Excel. Find out the steps to configure Excel WRITE communication to a PLC and boost your automation skills with RealPars. Visit RealPars.com for in-depth tutorials and guides.
Hello Members, I am looking to create a master sheet offline before heading out to the field. Can someone advise me on how to test and review tags while offline? I also need to access Program Tags, specifically those categorized as UDT_ANALOG. Your guidance on this matter would be greatly appreciated. Thank you.
I am currently using RSLINK Classic OEM version 4.00 and wondering if an ADDIN is necessary for Excel 2021 when utilizing VBA code with the OPC SERVER object. Thank you for your assistance.
Dear members, we kindly ask for your assistance. Thank you in advance.
Is a RSLinx Professional license and activation still required for using DDE, or has that requirement changed? It's been a while since I last used DDE, and although I have a license, I have since switched to an Ingear Developer license. Unlike RSLinx, which requires a license on every computer, Ingear only requires one license for the developer. Additionally, it is worth noting that VBA is no longer supported, as they have transitioned to Net.Studio.
Hey there, In my experience, KEPServerEX or a similar OPC server can be a great tool for extracting PLC data into Excel - it's especially user-friendly. When it comes to checking the sheet in OFFLINE mode, you might need to simulate the PLC tags first. Regarding the VBA code, I'd recommend integrating the RSLinx Add-In feature. Unfortunately, I don't have a specific VBA code to share, but there are many online resources on this subject that you can follow. Emphasis should always be on properly handling errors while reading data - it's crucial to your project's success. Hope this helps a bit!
Hi there! For your task, you have a couple options. If you'd rather go with a DDE link, setting up an Excel sheet with the respective tags and implementing the DDE read button should be pretty straightforward. To check the sheet offline, you can't exactly access real-time data since the PLC isn't directly connected, but you could potentially opt to download a specific batch of data for review offline. Concerning VBA, an add-in that often comes in handy with Excel 2021 is PI DataLink. For reading PLC data specifically, I prefer RS Linx coupled with RSLinx Classic Gateway, they offer a very reliable VBA solution. Note also that OPC servers can be beneficial. Lastly, I don’t have a specific code to share, however, ensuring your code is reading the precise tag names and matching the addresses correctly is the key to a reliable program. Hope that helps!
Hey there! It sounds like a great project you’re working on. For your DDE link, make sure your PLC supports it; otherwise, you might want to consider using OPC as an alternative. To check your Excel sheet in offline mode, you could keep a manual log of the values or set up a temporary mock database with sample tag values to simulate the data retrieval. As for VBA, the "Data Analysis Toolpak" is a good add-in to consider, but you might not need any specific add-in to read values unless you’re using external libraries. For the code, I’ve had luck using something like `Application.DDERequest` for reading data, but I can share a simple function to get you started if you’d like! Just let me know. Good luck!
Hey there! I’ve had some success with retrieving PLC tag values to Excel using DDE and VBA, so I can share a few tips. For your DDE link, make sure the PLC settings allow DDE connections; once you’ve configured it, creating a read button in your Excel sheet is pretty straightforward using forms. For offline mode, an idea is to set up a local copy of the tag values you can update manually when you’re back online. As for VBA, you don't need a specific add-in unless you’re using specialized libraries—just the built-in VBA should suffice. I’d recommend checking out some tutorials online for tested code snippets; you might find some open-source solutions on GitHub particularly useful. Let me know if you need more help!
✅ Work Order Management
✅ Asset Tracking
✅ Preventive Maintenance
✅ Inspection Report
We have received your information. We will share Schedule Demo details on your Mail Id.
Answer: - To achieve this, you can create an Excel sheet containing all the tags and utilize a DDE link with a designated read button. This allows you to establish a connection between the PLC and Excel for data retrieval.
Answer: - You can check the Excel sheet in OFFLINE mode by ensuring that the data retrieved through DDE link or VBA code is saved within the Excel file. This allows you to access and view the data even when not connected to the PLC.
Answer: - To retrieve data using VBA code, you may need to incorporate specific ADD-INS that are compatible with Excel 2021 and support communication with the PLC. Choose an ADD-IN that facilitates data exchange between Excel and the Logix 5000 PLC.
Answer: - It is recommended to search for tested and reliable VBA code snippets that have been specifically designed for reading data from a Logix 5000 PLC. These codes can help streamline the process of extracting tag values and ensure accurate data retrieval.
Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.