Hi all,

Can someone help me with the following:

For my work I need to import several txt files into an Excel workbook, after which the imported data is used for other calculations.
The location of the txt files is variable and needs to be given by the user.
Each txt file has to be imported to its own Excel sheet in the workbook, giving the Excel sheet the first 4 characters of the loaded txt file.
The number of txt files is variable also.

Does anyone have an idea how to tackle this?

Thanks in advance,
Martijn