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!
Hey there! It sounds like an interesting project you're working on! For your first step using DDE, you can easily set up a button in Excel that uses the DDE syntax to connect to your PLC tags. As for offline mode, just make sure to store the last fetched data in the sheet before going offline so you can still view the information. For VBA, you don't necessarily need a specific ADD-IN, but make sure to enable the Microsoft Forms 2.0 Object Library if you want to use user forms. In terms of sample code, you can find various snippets online that have been tested for PLC communication – just be sure to adjust them to suit your specific tag addresses. Good luck, and let us know how it goes!
Hey there! It sounds like an interesting project you're working on. For the DDE link, just make sure your PLC software is set up to allow DDE communication. You can create a button in Excel that triggers the DDE link to read values directly. To check your sheet in offline mode, you might consider setting up static values or using a local copy of the tags and their corresponding values. As for the VBA part, the Microsoft Visual Basic for Applications is included by default in Excel, so you won't need an additional add-in—just ensure your macro settings are enabled. As for code, I recommend looking into standard methods for reading cells directly linked to the DDE, or even starting with any existing examples and modifying them to suit your PLC's specific needs. Good luck, and I’m looking forward to hearing how it goes!
✅ 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.