I have an Excel 2010 file containing auto-updating cells with RTD. Example of cell:
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?