I have a spreadsheet that uses a DDE (dynamic data exchange) service link. The cell contains a formula where marketQuote is the DDE service:
=marketQuote|last!googl
The value of this cell is constantly changing. So, I would like capture every time the quote/value in the cell changes, and then store this value in an array (using vba/macro?) before the cell changes, and the previous value is overwritten and lost forever.
It is possible to do this in excel?