After data gets entered in the open workbook, the user clicks a command
button and data gets snet to another (closed) file.

"Andre" wrote:

How to transfer data from one Excel (open) file to a closed Excel file?
an one help me transfer data from an open Excel file to a closed one?