I have a macro that i run. The last part is to copy the data.

I then click over to an open text document and paste where the curser is,
which is at the bottom of the most recient data pasted.

Is there a way to have excel automatically, paste/export/whatever into a
specific text doc saved on my HD. I have to do this hundreds of times to
compile and any step i can automate is helpful.

Thanks.