I think you need to OPEN the text file for output, then WRITE to it
from code, before closing it - I would never use the copy and paste
method in code - too problematic, and what if a user starts doing
something else while the macro is running?