Simple macro excel
Employer
[no-member:pro]Igor[/no-member:pro]Igor
Project parameters
Type of cooperationOne-time project
SectionOther / Miscellaneous
Prepaymentprepayment is possible
Payment methodsCash, Bank transfer, Electronic money
Acceptance of requestsclosed
Project description
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]
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]
