I use an application that calls an excel spreadsheet in read only mode (and in the process closes any other spreadsheets that may be open), performs a number of calculations, stores the results of the calculations (temporarily) in that spreadsheet, returns the results to the application, then closes the spreadsheet.

is there a way to "capture" this data and copy it to another spreadsheet, after the calculations are complete, but before the app closes the spreadsheet?

for example, if the calculated results were stored in a1.e1000, I'd want to copy this data and put it in another spreadsheet, thus preserving same.

thank you.