Pc access continuously feeds data into excel. I am only going to capture thiss data every hour.
The data is always feeding into one cell. I just have to look at the cell and feed its contents into a worksheet.
That is exactly what I am trying to do. As far as the worksheet goes I dont have one created yet but it will always be the same workbook but will have to find the next empty cell to put the data in.
Jason
The pc access program is the only interface program I am using. The data is always being monitored in excel as it is continuosly updated...There are constant cells that the data is displayed. The data is always going to be in the same cell.
There are about 4 cells of data that will need to be...
I am using a siemens programmable logic controller to track our process. With the information I get get from the machines via PLC. I have a program called PC access. This allows me to pull values from counters and timers in the plc and display them into excel. My problem comes when I have the...
I have been working on a project where I have information coming from a PLC and ending up in excel. This much is done. My problem comes when I try to take the data from the cell it is in and make a running spreadsheet with the information. I need to shift information in every hour. Does anyone...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.