Tom@Pton (Customer) asked a question.
Excel and VFDs
Can an Excel spreadsheet be used to control a VFD? How would they interface or communicate?
Point me in a direction if you know.
Thank you
- ADC Community_02 (Automationdirect.com)
This may help get you going. It is using Excel to talk to a Do-more cpu but still relevant since it is using Modbus to talk to a slave device.
https://accautomation.ca/how-to-implement-modbus-tcp-protocol-using-vba-with-excel/?expand_article=1
Video:
- hadwalterss (Customer)
You can use Excel to control a VFD (Variable Frequency Drive) by setting up communication via a protocol like Modbus or using an interface like RS-485 or Ethernet. You’d likely need some extra hardware, like a Modbus to USB converter, and a VBA script or external software (like Node-RED) to send commands to the VFD based on the values you set in Excel.I had a similar project where I was controlling some industrial equipment through Excel. It took a bit of trial and error to get the communication working right, but it was so rewarding once it clicked!If you're just getting started, https://excel.tv/best-excel-courses/ offers some great courses to help you dive deeper into Excel and VBA, which could be super helpful for projects like this!
Expand Post
This may help get you going. It is using Excel to talk to a Do-more cpu but still relevant since it is using Modbus to talk to a slave device.
https://accautomation.ca/how-to-implement-modbus-tcp-protocol-using-vba-with-excel/?expand_article=1
Video:
https://www.youtube.com/watch?v=R4rexuNeH90