Merging txt documents into one document

I have a macro that copies several textdocuments into one document. The problem is that it adds a little squared box in the beginning of each new document that is pasted. Anyone who knows what the reason is?

Please Login or Register  to view this content.

Hi,

Thanks for your answer. I tried it.

When I paste into immediate window its like hitting enter. It breaks the code into two pieces and it doesn't look like I have been pasting anything.

The sign I want to move is a blank box.

I also have a problem with blank lines between some of the documents. I believe the macro would run smoother if I had some kind of select all, copy and paste function.

The sign I want to move is a blank box.

Using the CLEAN function removes all non-printable characters

Good. What more than clean. "Clean (7)"?

CLEAN(A1) is a worksheet function. I'm not versed in VBA but maybe this helps

But its a txt-document.

I understood that you merged your docs in an XL sheet sorry

No prob.

If the the macro was made to copy everything into excel, clean and remove blank lines, and then paste into a text document.

I don't know how the code should be written.

Does this link help ? http://www.rondebruin.nl/csv.htm

I didn't get much out of it.

Anyone who knows? Or do you all have summervacation?

It didn't work... still having the same problem. the macro didn't run with that command