Hello everyone,
I`m new to programming and I was wondering if someone could help me.
I recorderd the macro below. It imports data from a delimited text file into an Excel sheet.
This works fine, but I need to make some amendments:

1. The data should be imported into the active sheet in the active workbook instead of creating a new workbook/ sheet.
2. The macro should import data from all text files in a folder, rather than just one text file.
3. The name of the text file the data comes from should be inserted into the first column.

I will be greatful for any help/ suggestions.
Please Login or Register  to view this content.