Macro to Import Multiple TXT Files into workbook - User to select files/directory

'CSVs To One Sheet (Stacked)
A macro for importing all CSV files in a folder into a single Excel sheet, each CSV filename will be listed on the sheet next to the data that it came from.

CSVs to 1 Sheet - Part 1

Some suggested edits:

1) update the name of the sheet wsMstr so that it matches your master sheet name
2) The next line of code has a hardcoded fPATH where it will import all the files found in that folder. Your options are:

- enter a specific path and require your people to create that folder on their systems and drop the import files into there
- change that line of code to:

Please Login or Register  to view this content.

...and put this separate function into the module, too, to give the macro the ability to prompt for a folder selection:

Please Login or Register  to view this content.

3) Edit this line of code since your files are CSV files but have a TXT extension:

Please Login or Register  to view this content.

[QUOTE]

Originally Posted by saber007

I don't want it to import the files and create a new worksheet.
I want to import them and place them in the DATA worksheet that is already made.

Can this be done?

Originally Posted by JBeaucaire

1) update the name of the sheet wsMstr so that it matches your master sheet name

Look at the code, the parts marked in red are for you to edit.

Simplest solution is to have the macro rename the files as .CSV files, is that ok?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This seems dangerous. Certainly there is a specific sheetname? What is it?

Please Login or Register  to view this content.

I cannot locate this named range. Where is it?

Please Login or Register  to view this content.

That may be the problem, right there. Your files are .txt files still at this point, so the filter needs to be .txt, not .csv



Some other corrections:

Please Login or Register  to view this content.