Writing excel RTD to a file
I have an excel spreadsheet set up using the RTD function to update a row of values every 2 seconds. How can I get excel to append a csv or xls file with the RTD values every time they change? Alternately, can some code make the RTD row be copied and pasted to a new row so that all of the incoming data is saved? THANKS.
Software/Hardware used:
Software/Hardware used:
ASKED:
June 3, 2008 6:18 AM
UPDATED:
June 3, 2008 12:35 PM
Answer Wiki:
Hello RTD Guy,
I guess you are using VBA to refresh your data, if so add the following code (adjust it to fit your needs first), that will save the data to another sheet.
<pre>
Sheets("Sheet2").Range("A1")=Range("A3")
</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
