Simple macro excel

There are 2 files in one folder (let’s say C:1 drive), 1.xls and 1.cvs.
The 1.xls file on sheet 2 receives data on dde (the calculation of the update takes place), on sheet 1 the conclusions on the calculations in cells A1 and B1 (update approximately once every 1 second) are received.
It is necessary to make a macro so that the cells A1 and B1 (sheet 1, file 1.xls) are automatically displayed in the file 1.cvs (respectively in cells A1 and B1). Both files are open during operation (update in 1 second)
my mail: [email protected]