Copy & paste cells fr open worksheet then close the worksheet

[Guest]

Is it possible to have some code that copy some specific cells of the active
worksheet (from one workbook), then paste the data to specific cells of
another worksheet from a closed workbook. After the process is completed,
the code will automatic close the active workbook without saving (avoid the
reminder message of saving) then open the workbook is which the data was
saved, can anyone help?

 

[Dave Peterson]

Your code could open the second workbook.
The copy|paste the cells you want.
then save(???) the second file
then close the first workbook without saving.

If you record a macro when you do it manually, you may end up with the code you
want.