How to Import two consecutive text files in same column. No empty rows between.

[zeroJames]

Hello all,

Is there any way to create a macro that will import two text files consecutively into the same column without any empty rows inbetween? Please note, the first text file is always of different length and always ends in a different row. Thanks.

[MaczaQ]

of course it is possible, just give us some files for testing

[MaczaQ]

BTW I created for You following code

Please Login or Register  to view this content.

example files attached; just put them together in one folder and test.