Hi,
I would like to refresh the topic.
One of my customers wants to log some data to excel.
I read the hole topic but I still have some questions:
1. To log data I need to write VB macro. Where it should be written? In macros section? Or I should write some VB code which I can assign to each element on SCADA screen?
2. I need to write data values lets say once per day. Can I create every time new file or can I write values in new cells? Can I use variable from PLC to chenge excel cell number?
3. Is it posible to execute VB macro on trigger from PLC?
Thanks in advance for any help.
I would like to refresh the topic.
One of my customers wants to log some data to excel.
I read the hole topic but I still have some questions:
1. To log data I need to write VB macro. Where it should be written? In macros section? Or I should write some VB code which I can assign to each element on SCADA screen?
2. I need to write data values lets say once per day. Can I create every time new file or can I write values in new cells? Can I use variable from PLC to chenge excel cell number?
3. Is it posible to execute VB macro on trigger from PLC?
Thanks in advance for any help.