Скачать или смотреть How to Configure Real-time Microsoft Excel WRITE Communication to Rockwell Controllers (VBA)

▶ C'mon over to https://realpars.com where you can learn PLC programming faster and easier than you ever thought possible!

=============================

▶ Check out the full blog post over at
https://realpars.com/vba/

=============================

As an automation professional, you may require monitoring, controlling or testing using real-time manufacturing or process plant data from an Excel spreadsheet.

This data could be helpful also to your management, research and other department personnel requiring real-time data for decision making.

With this and the previous lesson (https://realpars.com/dde/), We’ll show you how to achieve this and more using Microsoft Excel and communication called Dynamic Data Exchange or DDE.

In this video, we will use Microsoft Excel to write data to Rockwell Automation Studio 5000, using RSLinx Classic and Studio 5000 Logix Emulate software.

The Studio 5000 Logix Emulate will communicate with RSLinx Classic and in turn, RSLinx will communicate with Studio 5000 Logix Designer and Microsoft Excel.

DDE is a Windows mechanism that enables applications to communicate with each other. A DDE communication is known as a conversation between Client, which initiates the conversation, and Server, which responses to the request.

To initiate a DDE conversation, a client specifies the three items:

The Application, the name of the application it wants to talk to. Usually, this is the application executable’s filename, for example, RSLinx.

The Topic, the subject of the conversation created by the user and should be something which makes sense, for example, RealParsExcel.

And Item; Any number of different Items may be referred to identify data to be passed between the applications, for example, Excel recognizes cell references as items and RSLinx recognizes program tag names as items.

We will begin with the sample PLC program. We’ve created a Studio 5000 Logix Designer program called Realpars_Excel.
You can download this PLC program here:
https://bit.ly/4fmBOmp

We will set up the DDE configuration for Excel. You can download the Excel file here:
https://bit.ly/Excel-PLC

We will write the VBA code that will perform the VBA RSLinx connection and write operation to the PLC. For more information about VBA code used in this project, check out the full blog post over at:
https://realpars.com/vba/

=============================

Missed our most recent videos? Watch them here:

https://realpars.com/remote-io/

https://realpars.com/dde

https://realpars.com/fds/

=============================

To stay up to date with our last videos and more lessons, make sure to subscribe to this YouTube channel:

http://goo.gl/Y6DRiN

=============================

TWEET THIS VIDEO https://ctt.ac/f5cpt

=============================

Like us on Facebook:   / therealpars  

Follow us on Twitter:   / realpars  

Follow us on LinkedIn   / realpars  

Follow us on Instagram   / realparsdotcom  

#RealPars #VBA #Automation