I need help getting data into Microsoft Excel from Allen-Bradley PLC automatically ... By RE on 11 July, 2002 - 4:42 pm. I need help getting data into Microsoft Excel from an Allen-Bradley PLC automatically each time an event happens. For example, each time an alarm for a steam valve turns on, I need to record date, time, and duration of the problem. I can write the PLC code to gather the information. 1 On the File menu, click New, and then click Project. 2  Select Windows Application from the Visual Basic Project types. 3  By default, Form1 is created. 4  Add a reference to Microsoft Excel Object Library. 5  To do this, follow these steps: 6  On the Project menu, click Add Reference. I need help getting data into Microsoft Excel from Allen-Bradley PLC automatically ... By RE on 11 July, 2002 - 4:42 pm. I need help getting data into Microsoft Excel from an Allen-Bradley PLC automatically each time an event happens. For example, each time an alarm for a steam valve turns on, I need to record date, time, and duration of the problem. I can write the PLC code to gather the information. 1 Start Microsoft Visual Studio .NET. 2  On the File menu, click New, and then click Project. 3  Select Windows Application from the Visual Basic Project types. 4  By default, Form1 is created. 5  Add a reference to Microsoft Excel Object Library. 6  To do this, follow these steps: 7  On the Project menu, click Add Reference. CHAPTER 4 – Reference OMRON Revision 3.0 80 Use the following procedure to add a PLC to a project. 1, 2, 3… 1. Select the Project object in the project workspace. 2. From the Insert menu select PLC or right click on the project folder and select Insert PLC.
http://control.com/thread/1026233108 https://support.microsoft.com/en-us/kb/302094 http://control.com/thread/1026152850 https://support.microsoft.com/en-us/kb/302094 http://www.proenergo.ru/doc_pdf/soft/CX-Programmer.pdf
how to insert excel file to omron plc