![]() To continue with my OpenHab project (view which lights are on, …), I need to find a way to read the data of the PLC in OpenHab (through the DLL-file). I can write in VBA and, as Java is not very much different then Visual Basic, I think I can manage Java also.Ĭurrently I have already a (very basic) project working with openhab and my intentions are to run it on a Windows PC which I also will use as a multimedia server. I have bought a second one to experiment and I already was able to access, read and write in Excel Merker Values to and from the PLC using VBA. ![]() Serial Port Communication in Excel (VBA) Introduction to Serial Port Communication in VBA. The PLC itself communicates with RS232, but there is an DLL file so you can communicate to excel, … Microsoft Excel Essentials: Level 3 - VBA Programming+Macros. CommOpen checks to see if the specified port is open. CommOpen takes three parameters: the Port ID mentioned above, a port name such as 'COM1' and the desired communication settings (Example: 'baud9600 parityN data8 stop1'). ![]() The PLC is controlling all lights, hot water boiler, … and the entire house is foreseen with push buttons.Īs I already have this splendid system, it would be a pity if I couldn’t integrate it with openhab. For example, the CommOpen routine can be used to open and initialize a serial port. At home I have an elder PLC (Moeller PS4 - ± 20 years old ) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |