Dear Sirs,
I wander Whether it is possible to track history of data connection output results without VBA.
For example, there is daily updated table in the internet in the format {date;value}
It was loaded into Excel Data Table with help of web query.
Each day on update of table old data erased.
How make this table appended by new data?
today; 10
yesterday ; 100
day before yesterday; 1
...
----------
Os Win7; Ms Excel 2013
----------
Thank you for any ideas.
I wander Whether it is possible to track history of data connection output results without VBA.
For example, there is daily updated table in the internet in the format {date;value}
It was loaded into Excel Data Table with help of web query.
Each day on update of table old data erased.
How make this table appended by new data?
today; 10
yesterday ; 100
day before yesterday; 1
...
----------
Os Win7; Ms Excel 2013
----------
Thank you for any ideas.