Copy text files underneath each other

**ditöle** · 03-03-2013, 04:16 AM

Dear Experts,

I have about 400 text files and I want to put them underneath each other in an excel sheet. The columns are always from A to O but the amount of lines variates.

I have this macro but it always stops at VerzVar = Dir(Pfadname & "*.txt").

Furthermore, it is possible to embed the deleting of the first line of each text file first?

Thanks heaps!!
Stefan

(I use Ecxel 2010 on a Mac 10.6.8)

Please Login or Register  to view this content.

**Alf** · 03-03-2013, 12:24 PM

I'm a bit puzzled should not the line with "Pfadname" read

Please Login or Register  to view this content.

and I think you are missing a backslash so you either add it to the "Pfadname" string or you change "VerzVar" to

Please Login or Register  to view this content.

Alf

Sorry just reread your post and see you are using the Excel Mac version so I'm not sure my advice will help you at all.

**ditöle** · 03-03-2013, 01:36 PM

Hey Alf,

thanks heaps for your answer. I have tried it. Unfortunately it did not work, though. I have even tried it with / and with \. It still stops at

Please Login or Register  to view this content.

**Alf** · 03-03-2013, 02:52 PM

Perhaps you may find something of interest in this link? Allmost at the bottom of the page there is an example "Loop through all files in a folder on a Mac"

http://www.rondebruin.nl/mac.htm#Loop

Alf

**ditöle** · 03-03-2013, 03:27 PM

That sounds very interesting!!! I will have a closer look at it tomorrow. Thanks heaps!!!

**ditöle** · 03-05-2013, 05:29 AM

Dear Alf,

I have tried it and it works perfectly fine. Thanks!!!!

**Alf** · 03-05-2013, 07:28 AM

Glad to be of help and thanks for feedback.

Alf

Ps Don't forget to mark your thread "Solved"

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save