move text using vba

Good Night,

I have a code that transfer a number into a different file, but now I want to use it to transfer a text instead.

Do you have a solution for my problem.

I already attached the file and the solution that I need in there. the code was already in Feedmaster## file if you need to.
I have no idea how to modify the code to identify a text instead a number.

Regards,