How to Program Microsoft Excel as a Modbus Master HMI
What you'll learn
- Have an understanding of how ActiveX controls work with Microsoft Excel
- Install the MBAXP Modbus ActiveX control in Microsoft Excel
- Write VBA code to read Modbus data from a Modbus Slave/Server
- Write VBA code to write Modbus data to a Modbus Slave/Server
- Use Modsim32 as a Modbus Test Slave and Server
- Establish both Modbus Serial and TCP/IP Communications using Microsoft Excel
Requirements
- Basic working knowledge of the Modbus RTU protocol.
- Familiarity with the installation of software applications on the Windows OS platform
- Elementary understanding of the "BASIC" programming language
Description
If you design and implement projects in the area of Process Automation or SCADA, you will know from your experience that "one size does not fit all" when it comes to data acquisition and Human Machine Interfaces (HMIs). There is always some type of customization to be done. Always some feature that the standard HMI software does not offer.
And sometimes, using a very expensive HMI with all sorts of bells and whistles for a small project can just be overkill. There are times when you just need a very simple application that acquires a few data points from a Modbus network and displays them on a computer screen.
These are the reasons for this course!
I teach you how to use Microsoft Excel to create your own Modbus Master application and Human Machine Interface.
If you apply yourself in this course and execute all that I ask you to do, then at the end, you would be essentially be creating an application with all of the superb data analysis capabilities of Microsoft Excel and applying it to Modbus data!
This is the start of your journey into a whole new area of Process Automation / SCADA and one that is increasingly in very high demand!
Looking forward to seeing you on the inside!
Who this course is for:
- Electrical Engineers
- Electrical Technicians
- Electrical Tech or Engineering Students
- Process Control Technicians and Engineers
- Process Automation Engineers
- Programmers working in the Process Automation field
Instructor
![Emile Ackbarali](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.6 Instructor Rating
- 11,285 Reviews
- 22,550 Students
- 23 Courses
I have been working in the fields of Software Development, Software Systems Integration and Process Automation since 1996. In 2003, I stepped out on my own and started working for myself providing software development and systems integration services to small and medium businesses.
I am also associated with a great company called Mora Systems Limited that under the leadership of it's Managing Director has produced innovative and outstanding products and services in the fields of GIS and Cellular based SCADA.
Teaching has always been a passion for me. I have taught at the tertiary level for many years on the subjects of programming, control systems as well as systems integration. In the last few years I found myself incorporating more and more videos into the curriculum with amazing results.
When I heard of uDemy I just could not help but sign up. With teaching in a classroom, you can reach only so many students, but with uDemy you can reach the world! I plan to publish and promote as many courses as I possibly can on the uDemy platform.