adccommunitymod (AutomationDirect) asked a question.
Export data to Excel
Created Date: July 04,2019
Created By: sahriah19
**** This post has been imported from our legacy forum. Information in this post may be outdated and links contained in the post may no longer work.****
Hi all, I have directlogic 06 D0-06DR and directsoft 5 connected to pc at usb from port 1. This is my first time working with this brand. I want to export data from v-memory to excel. Can I do this with the existing things that I have? I read somewhere can use vba in excel to do this. is it true? Thank you.
Created Date: July 04,2019
Created by: sahriah19
Hi all,
I have directlogic 06 D0-06DR and directsoft 5 connected to pc at usb from port 1. This is my first time working with this brand. I want to export data from v-memory to excel. Can I do this with the existing things that I have? I read somewhere can use vba in excel to do this. is it true? Thank you.
Created Date: July 04,2019
Created by: Garry
The D0-06DR can understand the Modbus RTU protocol. You will need to use VBA to open the serial port, send the Modbus command for the data, read the return data and then display in excel.
https://pps2.com/smf/index.php?topic=25.0
The above link has a sample code for Modbus RTU using VBA.
Here is the post I have done using Modbus TCP (Ethernet) to get information into excel.
https://accautomation.ca/how-to-implement-modbus-tcp-protocol-using-vba-with-excel/
Hope this helps you out.
Regards,
Garry
Created Date: July 04,2019
Created by: Garry
https://forum.automationdirect.com/forum/communications/123121-dl06-v-memory-to-excel
The above post may also help you out.
Regards,
Garry
Created Date: July 05,2019
Created by: z28z34man
I have been playing around with python.
It wouldn't be all that hard to create a python script to poll the modbus address you want and append it to a csv at a rate you define.