How to Program Microsoft Excel as a Modbus Master HMI

Learn how to use Microsoft Excel to communicate Serially or via TCP/IP with any Modbus Slave

4.20 (253 reviews)

Udemy

platform

English

language

Other

What you will 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

Why take this course?

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!

Screenshots

How to Program Microsoft Excel as a Modbus Master HMI - Screenshot_01

How to Program Microsoft Excel as a Modbus Master HMI - Screenshot_02

How to Program Microsoft Excel as a Modbus Master HMI - Screenshot_03

How to Program Microsoft Excel as a Modbus Master HMI - Screenshot_04

Reviews

Gonzalo

March 4, 2023

The course was extremely clear and useful for me. As soon as I finished it, I could succesfully meet my initial goal which was to establish a modbus tcp link between an Excel spreadsheet and a Schneider M221 plc. Thanks a lot to the teacher for this course, now I'm sure I'll take other courses from him in the near future.

Fernando

March 1, 2023

Una forma rápida y sencilla para controlar/leer equipos usando MODBUS y EXCEL. Lo pondré en practica. Gracias.

Michael

March 1, 2023

I have taken a few courses with this instructor. very clear instruction and easy to understand for beginners. I am an EE with emphasis on controls and I have learned a lot.

Charles

July 5, 2022

Great course, the content is wonderful and well explain. I really enjoy it and I actually after the course I was able to modify the code to write to any Holding Register and Coil address! This Excel Program is a powerful tool for Modbus Testing and Troubleshooting. Two thumbs up!

Daniel

August 20, 2021

I dont give you 5 stars, because i would like that you did a connection with a dispositive extern. But it is a good course.

Liam

January 26, 2021

Great little course, helpful with the configuration and set up, clear enough with the delivery to enable me to move away from the simulator and on to hardware within the hour. Very happy!

Kenny

December 11, 2020

I am yet to find another instructor with a better delivery than Emile. His approach to teaching and his explanations are so clear that one does not have to struggle to understand the basics of his courses. No wonder I keep enrolling for the courses. This is my 5th and am still going.

Olivier

November 5, 2020

Straight to the point, clear and complete. I have now all the tools I need to design an HMI and a datalogging systeme via Excel. I've been loosing lot of time searching those info on the web. I highly recommend this course.

Karl

June 25, 2020

Again, Emile has created a "straight to the point" no fluff course. Excellent. I'm already using this for testing a couple of applications.

June 9, 2020

Was good on the Excel tools and configuration. Would have benefited from a bit more how to set things up on the PLC side (understanding that there are many different types, but even just demonstrate one - how to setup registers, Modbus comms, etc).

Pasupathy

April 13, 2020

Course introduced a few things which speeded up the development of excel based monitoring and control of Modbus devices. as a negative, the use of licensed libraries and software was not mentioned until the enrolment.

Balaji

March 26, 2020

This is really followable and executable course. I have created couple of examples... thanks to the instructor

Luis

March 14, 2018

Congratulations Emile! another excellent course. I still can't solve that issue with excel, but I could do all the exercises. I am hoping you to make more automation courses like these, have a good day.

Bryan

March 11, 2018

Helped me understand the VBA side to get MBAXP Modbus ActiveX Control running the way I wanted. My goal was to get a HMI put together for trouble shooting end devices. He showed me everything I needed to accomplish the task.

John

December 8, 2017

As usual, Emile is right on. Comprehensive friendly style. Repetition (but not overly so) helps to reinforce concepts. The only minor thing is that IMHO it is stretching it a bit to consider Excel a full fledged HMI without adding other widgets such as meters, sliders, etc. Great course though.

Charts

Price

Rating

Enrollment distribution

How to Program Microsoft Excel as a Modbus Master HMI - Distribution chart