Writing excel RTD to a file

10 pts.
Tags:
Excel functions
Excel macros
Microsoft Excel
RealTimeData
RTD function
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following