Data Streamer Function

[mrpoo]

Hello all,

I'm using the Data Steaming function to record an airflow reading from an external device then plot it on a chart.
I've configured Data Streamer to record 1200 rows that equates to 20 mins (ish), It all works lovely up until all the specified rows have had filled then any readings over the 1200 row mark (20 mins) starts over writing existing data in row 1200.

I've played around with the Data Streamer Settings but they are very limited but I'm wondering if there is a way to insert the contents from a cell in another once it has been populated the first time but not over write when the original data is updated?

Am I talking gibberish?

Many thanks,
Graham

 

[sijpie]

Possibly.

In the worksheet module you could set up a worksheet_Change() function that locks the cell 1200 once it has been changed.

You would also need a small clear/unlock macro for the next time you want to collect data.