Merging txt files using VBA into a current worksheet

Hi Everyone

I am trying to merge txt files using VBA into a current worksheet.
The first line of each txt file is NOT to be merged.
The LOG file is to be imported into specific columns in a current worksheet as adjacent columns containing formulas will access this data.
I have managed to import the first LOG file but I do not understand how to create a loop to repeat the import for all txt files.
I have included a tab "Merged files when imported" to show what the program should do when the 3 files are correctly imported

Many thanks in advance for your help. I am new to programming

Chris

Working with "UTF-16" here.
If this doens't work at your end, try change to "UTF-8"
Assuming all files incl. master workbook are in the same folder.

Please Login or Register  to view this content.

Hi Jindon
Thank you for your reply. however, I receive a runtime error 1004 when I run the macro
IN VBA the line With [a3].Resize(n) is highlighted
Chris

See the attached,
"my result" sheet is the result I got.

The + operator has the main purpose of adding two numbers.