Extracting RTD (Real Time Data) from Excel file
- by Mat0930912
Hi everyone.
I have an Excel 2010 file containing auto-updating cells with RTD.
Example of cell:
=RTD("xxx";"yyy")
I need to extract (in a .txt file) those cells' values, every X minutes.
My .txt file MUST contain the updated value.
I tried with a macro. That macro exports every X minutes a txt file of the Excel file.
The problem is that when macro is running, cells doesn't update: the values remain the same of those before the macro was launched. It looks like macro forbids the updating.
How can I do?
Thank you.