H
Not difficult to create HMI applications using Microsoft Excel and HINET Modbus DDE Server.
The steps are ]:
<b>MODERATOR'S NOTE: If you do this please let us know how it works. Thank you</b>
1. Download HINET Modbus DDE Server application here -> https://dl.dropboxusercontent.com/u/3351822/HINETIOServer.rar
2. Extract the two files (HINET.exe and HINET.mdb) into a folder.
3. Run HINET.exe
4. Enter the Serial Number of the product Hinet you use, then click the Verify button.
Figure: https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_01.jpg
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_02.jpg
5. Fill in your details on the Company Name , Contact Person , User Name and Password , then click the save button.
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_03.jpg
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_04.jpg
6. Next.. click the Configure menu , and select the sub-menu "DDE Topic Definition"
Figure :
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_05.jpg
7. After that , enter the User Name and Password that you created before.
Figure :
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_06.jpg
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_07.jpg
8. Next... click the 'New' button.
Figure :
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_08.jpg
9. After that, input the details of the configuration of a Modbus Slave device that you want to poll.
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_09.jpg
10. And then, create a DDE Item Name Tag , complete with modbus address, data type and length, one by one..
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_10.jpg
11. When it is filled , then click OK. So application back to DDE Topic Definition Window. If you have finish, then click 'DONE'.
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_11.jpg
12. Furthermore .. Run Microsoft Excel and create a new Worksheet.
13. In the Formula Bar , complete with DDE functions like the example below:
= HINET|omni!year
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_12.jpg
14. After that, go back to take another DDE Item name tag that has your configuration in HINET Modbus DDE Server.
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_14.jpg
15. Now you can monitor a real-time data that is in the Modbus device usin Microsoft Excel and HINET Modbus DDE Server
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_13.jpg
Thank you for your attention.
The steps are ]:
<b>MODERATOR'S NOTE: If you do this please let us know how it works. Thank you</b>
1. Download HINET Modbus DDE Server application here -> https://dl.dropboxusercontent.com/u/3351822/HINETIOServer.rar
2. Extract the two files (HINET.exe and HINET.mdb) into a folder.
3. Run HINET.exe
4. Enter the Serial Number of the product Hinet you use, then click the Verify button.
Figure: https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_01.jpg
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_02.jpg
5. Fill in your details on the Company Name , Contact Person , User Name and Password , then click the save button.
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_03.jpg
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_04.jpg
6. Next.. click the Configure menu , and select the sub-menu "DDE Topic Definition"
Figure :
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_05.jpg
7. After that , enter the User Name and Password that you created before.
Figure :
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_06.jpg
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_07.jpg
8. Next... click the 'New' button.
Figure :
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_08.jpg
9. After that, input the details of the configuration of a Modbus Slave device that you want to poll.
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_09.jpg
10. And then, create a DDE Item Name Tag , complete with modbus address, data type and length, one by one..
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_10.jpg
11. When it is filled , then click OK. So application back to DDE Topic Definition Window. If you have finish, then click 'DONE'.
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_11.jpg
12. Furthermore .. Run Microsoft Excel and create a new Worksheet.
13. In the Formula Bar , complete with DDE functions like the example below:
= HINET|omni!year
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_12.jpg
14. After that, go back to take another DDE Item name tag that has your configuration in HINET Modbus DDE Server.
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_14.jpg
15. Now you can monitor a real-time data that is in the Modbus device usin Microsoft Excel and HINET Modbus DDE Server
Figure:
https://dl.dropboxusercontent.com/u/3351822/HINET_Frame_13.jpg
Thank you for your attention.